Advanced Search

Question: ExcelTools / import cells as text when cell format is text?

Question:ExcelTools / import cells as text when cell format is text?

Anthrazit 770 Maple
string import exceltools
May 28 2022
0

Is there a way to importing cell values as text, and not numbers, when the cell is formatted as a text?

As far as I can see, a cell with the value "1" is always import as "1.0" in ExcelTools, regardless if the cell is formatted as text or something else in Excel.

Writing '1 in the Excel cell however leads to a text import in Maple, and will give "1", not "1.0".

There is one more thing that is strange in Excel. Even if the cell is formatted as a text, or the cell content is with a ' before the number, Excel will allow a calculation with that value. Text value 4 will give 5, if added 1.
Please Wait...