Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline Farja  
#1 Posted : 26 February 2019 17:47:01(UTC)
Farja

Rank: Newbie

Groups: Registered
Joined: 05/01/2018(UTC)
Posts: 7
Chile
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 Confusion ), and the other was typed directly.

2019-02-26 11_38_48-Window.png

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

thanks 1 user thanked Farja for this useful post.
on 26/02/2019(UTC)

Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

Offline Davide Carpi  
#2 Posted : 26 February 2019 21:53:54(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
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
Offline Farja  
#3 Posted : 26 February 2019 22:57:51(UTC)
Farja

Rank: Newbie

Groups: Registered
Joined: 05/01/2018(UTC)
Posts: 7
Chile
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
Offline Davide Carpi  
#4 Posted : 27 February 2019 02:57:46(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: Farja Go to Quoted Post
i was using the Excel I/O plugin (EXCEL (2003 ) I/O with recalculation and PNG export


Updated. Good
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline Farja  
#5 Posted : 28 February 2019 20:39:48(UTC)
Farja

Rank: Newbie

Groups: Registered
Joined: 05/01/2018(UTC)
Posts: 7
Chile
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

Users browsing this topic
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.