String updates as inlineString

[DaKar00]

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 "<IGNORE>" or "<ADD>", 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