Rank: Newbie
Groups: Registered
Joined: 05/01/2018(UTC) Posts: 7 Location: Zzz Was thanked: 1 time(s) in 1 post(s)
|
I was having problems importing an excel file, thought it was a problem with the extension, but some sheets continued to work. The problem was due to the name of the file used as argument to the plugin. The only difference between the strings shown below, is that in the first case the name was copied from a windows explorer window and pasted between ""(lazy me ), and the other was typed directly. Both look the same, but SMath stores them differently, and when passed as an argument to the plugin, it fails. Var_String1: Code: <math>
<input>
<e type="operand">var_string1</e>
</input>
<result action="numeric">
<e type="operand" style="string">M2U4\005F\m03\005F\2\005F\Error\002E\xlsx</e>
</result>
</math>
Var String2: Code: <math>
<input>
<e type="operand">var_string2</e>
<e type="operand" style="string">M2U4_m03_2_Error.xlsx</e>
<e type="operator" args="2">:</e>
</input>
</math>
Error ST.sm (5kb) downloaded 11 time(s).Excel plugin: https://en.smath.info/fo...yaf_postst4375_Plugin---EXCEL--2003--I-O-with-recalculation-and-export-to-PNG.aspx
|
1 user thanked Farja for this useful post.
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,639 Location: Italy Was thanked: 1323 time(s) in 873 post(s)
|
XlsxImportExport plugin updated; please let me know if it works properly so I'll update similar plugins. |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Newbie
Groups: Registered
Joined: 05/01/2018(UTC) Posts: 7 Location: Zzz Was thanked: 1 time(s) in 1 post(s)
|
Thanks Davide, i was using the Excel I/O plugin (EXCEL (2003+) I/O with recalculation and PNG export - 1.99.6849.42653), but the problem also applies to XlsxImportExport plugin.
The updated XlsxImportExport plugin (1.3.6996.39330) work properly with the same problematic strings (space, underscore, dot, etc). So i will switch to this one.
Best regards, Farja
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,639 Location: Italy Was thanked: 1323 time(s) in 873 post(s)
|
Originally Posted by: Farja i was using the Excel I/O plugin (EXCEL (2003 ) I/O with recalculation and PNG export Updated. |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Newbie
Groups: Registered
Joined: 05/01/2018(UTC) Posts: 7 Location: Zzz Was thanked: 1 time(s) in 1 post(s)
|
Thanks Davide, Both plugins work fine now. Best regards, Farja Edited by moderator 01 March 2019 21:10:06(UTC)
| Reason: marked as Solved
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.