[SOLVED] Error while importing work

Hello,
I'm having an exception while trying to import work in projeqtor.
I've got several excel files in order to do so.They've got the same format (as requested by projeqtor) and i succeded import 5 excel files and i don't understand why this one is raising an exception.

here's the logs
2018-07-24 14:34:43.058 ***** ERROR ***** [V7.0.9] EXCEPTION *****
2018-07-24 14:34:43.058 ***** ERROR ***** [V7.0.9] on file 'D:\xampp\htdocs\projeqtor\external\XLSXReader\XLSXReader.php' at line (152)
2018-07-24 14:34:43.058 ***** ERROR ***** [V7.0.9] cause = Sheet ID 1 does not exist in the Excel file
2018-07-24 14:34:43.059 ***** ERROR ***** [V7.0.9] => #0 D:\xampp\htdocs\projeqtor\external\XLSXReader\XLSXReader.php (135) -> getSheetNameById()
2018-07-24 14:34:43.059 ***** ERROR ***** [V7.0.9] => #1 D:\xampp\htdocs\projeqtor\model\Importable.php (588) -> getSheet()
2018-07-24 14:34:43.060 ***** ERROR ***** [V7.0.9] => #2 D:\xampp\htdocs\projeqtor\model\Importable.php (159) -> importXLSX()
2018-07-24 14:34:43.060 ***** ERROR ***** [V7.0.9] => #3 D:\xampp\htdocs\projeqtor\tool\import.php (112) -> import()

Hi,
I've had similar issues with Excel (not sure if it was with Projeqtor or other tools) : it can be an issue if the original 'Sheet1' from the Excel was deleted.
To workaround : create a brand new Excel file, and copy-paste all your data from the current file into the new one.

Hope it helps

it kinda work the importing tool said no error but when i check on the timesheet screen their is nothing for this resource

i checked in the data base and their is no value on field refId (all fields set to 0) and on idAssignement( all fields set to Null) while in my excel sheet i've got every field fill


Projeqtor desn't take these fields into concideration

thanks for your help i tried both solutions and it work!
but know i'm facing (again) another issue. When i want to import another excel file containing work i've got this error

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes) in D:\xampp\htdocs\projeqtor\external\XLSXReader\XLSXReader.php on line 214

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 12288 bytes) in Unknown on line 0


I dont really understand this error because this particular file is not that bigger than my previous one. Like 5KB bigger