Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
It is something in the workbook content, can't say much more without the file |
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: 24/01/2011(UTC) Posts: 8 Location: Волгоград
|
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
I cannot reproduce the issue; please try if with the new beta you get more informations from the error message. |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
1 user thanked Davide Carpi for this useful post.
|
|
|
Rank: Newbie
Groups: Registered
Joined: 24/01/2011(UTC) Posts: 8 Location: Волгоград
|
The new beta version is working, thank you!
|
|
|
|
Rank: Guest
Groups: Registered
Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 981 time(s) in 809 post(s)
|
Originally Posted by: mikka File attached Excel file not attached !
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 10/01/2017(UTC) Posts: 31 Location: Alberta
|
Hi, I was using this great plugin and found that sometimes it does weird thing. for instance, it gave an error and I had to re-write the import/export expression to make it work again. but now I am stuck with something that I don't understand why it is happening, when I want to read from cell K11 the result is 1.01 instead of 0.86 trying other cells will give correct results except K11 will not return the correct value. Thanks!! Another point, in the attached file, I am using both import and export functions, when I update any variable in my SMath sheet, the results in Excel is updated but the results in SMath do not change (the import function does not refresh and if I manually refresh it, still I am stuck with old values), why? Temp.zip (9kb) downloaded 44 time(s).Edited by user 18 April 2019 17:11:24(UTC)
| Reason: Not specified
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/06/2014(UTC) Posts: 348 Location: Colombo Was thanked: 125 time(s) in 82 post(s)
|
Originally Posted by: Mido0 Hi, I was using this great plugin and found that sometimes it does weird thing. for instance, it gave an error and I had to re-write the import/export expression to make it work again. It works for me. Close Excel file and Recalculate the SMath file. SMath displays an error if Excel file is open. Edited by user 18 April 2019 17:32:43(UTC)
| Reason: Not specified |
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka |
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 10/01/2017(UTC) Posts: 31 Location: Alberta
|
It worked when I closed both Excell and Smath and opened SMath again. but the problem now, is when I change the inputs, say ts=22mm the output (calculated value from excel) does not update, which is essential in a sheet like that.
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 05/06/2014(UTC) Posts: 348 Location: Colombo Was thanked: 125 time(s) in 82 post(s)
|
Originally Posted by: Mido0 but the problem now, is when I change the inputs, say ts=22mm the output (calculated value from excel) does not update, which is essential in a sheet like that Hi Mido0, Yes you are correct. Sorry for my earlier feedback. Hope some one may be able to help. |
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka |
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,647 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
I'll check what I can do but the backbone of this plugin is the indipendence from excel (is not required nor used at all). You can get and set data inside xlsx files even in hostile environments, f.e. when MS excel isn't available because another program is installed or none is available at all. The possibility of performing calculations before getting the data or after saving it is probably possible, but isn't made by excel; this means that some functions might be missing and probably you should double-check the result. To perform calculations on the fly inside excel the right plugin is this: EXCEL (2003+) I/O with recalculation and export to PNGEdited by user 20 April 2019 11:36:18(UTC)
| Reason: typo |
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: 01/06/2017(UTC) Posts: 5
Was thanked: 3 time(s) in 2 post(s)
|
Импорт информации из Excel Import from Excel
|
2 users thanked KhasanMamaev for this useful post.
|
on 17/11/2019(UTC), on 29/04/2020(UTC)
|
|
Rank: Newbie
Groups: Registered
Joined: 21/02/2021(UTC) Posts: 1
|
Please help me, if you can. I have a problem when importing numbers with units of measurement. Using SMath Studio Desktop v 0.99 build 7610 with XlsxImportExport 1.3.6996.39330 When I try to import a number with units of measurement from xlsx document, like for example: 2300 * {'kg *' m} / {'s ^ 2} in SMath Studio, I get string variable as a result: "2300 * {' kg * 'm} / {' s ^ 2} ". How can I get number with units of measurement type variable, like this Source document: my SMath XLSX input.xlsx Example, before recalculation: Example, after recalculation: Software versions:
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,356 Was thanked: 815 time(s) in 516 post(s)
|
Hi. You can try to apply this algorithm, and see if you are satisfied with its result: Best regards. Alvaro.
|
|
|
|
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.