Import Datatable exported excel gives error: Cell coordinate can not be zero-length strin

patelleena57

Hello,

I am trying to import excel files in my database using PHPExcel.

It is working fine in some cases

But when i import excel file which is exported from datatable it throws this error
"Error loading file "phpoYGi50": Cell coordinate can not be zero-length string"

It is working fine in any other excel but only in case of excel exported by datatable it throws error.

Any suggestion will be appreciated.

Thanks in advance

allan

Are you able to give me a link to the page that shows the DataTable that creates such a file. Certainly DataTables' export should not be created a cell coordinate with a zero length - that is a bug if so and I'd like to figure out why that is happening.

Allan

patelleena57

Can i provide code of my datatable? because i cant share details because of privacy.

patelleena57

Or you can try exporting data from datatable and importing it using phpexcel without editing excel because if we edit excel it changes cell coordinates length.

Thanks
Leena

allan

Hi Leena,

Does it happen for you if you use an Excel file exported from this example? If so I can base my investigation on that.

Allan

patelleena57

Hi Allan,

It does not happen when i tried that excel it imports data. I think in my datatable code there is an error.

Can you help what could be the error?

Leena

patelleena57

Hi Allan

Issue is solved. I had old package of buttons. Now i replaced it with newer.

Thanks