Hi, i just want to start by saying that this package saved my project!.
I was using another popular package to work with excel files and that package had a bug that shifted the cells around making it useless for my application.
My application:
Im reading an excel file that was generated as an export from a maintenance system, then my application extracts data and organizes it with child / parent relations, then generates import files in order of the child / parent relation.
My problem:
When my files are generated (Import 1, Import 2, Import 3) and so on, a cell in the file gets marked with "" or "", the maintenance system then reads those cells to ether skill or add that row to the system, when the system reads the cell i get an exception saying that the cell format is of type "InlineString" and needs to be of type "String".
Now i get around the problem by opening the excel file, selecting the column, format cells, change type to "Text".
Is there a way to modify cell as "String" and not "InlineString" type?
I found this link that might give an idea of how to fix this (from C# but the xml part might give an idea).
https://stackoverflow.com/questions/6468783/what-is-the-difference-between-cellvalues-inlinestring-and-cellvalues-string-in
Hi, i just want to start by saying that this package saved my project!.
I was using another popular package to work with excel files and that package had a bug that shifted the cells around making it useless for my application.
My application:
Im reading an excel file that was generated as an export from a maintenance system, then my application extracts data and organizes it with child / parent relations, then generates import files in order of the child / parent relation.
My problem:
When my files are generated (Import 1, Import 2, Import 3) and so on, a cell in the file gets marked with "" or "", the maintenance system then reads those cells to ether skill or add that row to the system, when the system reads the cell i get an exception saying that the cell format is of type "InlineString" and needs to be of type "String".
Now i get around the problem by opening the excel file, selecting the column, format cells, change type to "Text".
Is there a way to modify cell as "String" and not "InlineString" type?
I found this link that might give an idea of how to fix this (from C# but the xml part might give an idea).
https://stackoverflow.com/questions/6468783/what-is-the-difference-between-cellvalues-inlinestring-and-cellvalues-string-in