Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Originally Posted by: ElSid Does this or any other "excel" plugin work with "ods" extensions? I am on Libre office on both Windows and Linux at home. I could not get to work. Look here: Data Exchange plugin |
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: 30/11/2015(UTC) Posts: 1 Location: Vereeniging
|
Hi Davide, I had successfully used the plug-in until Excel 2016 / Windows 10 (or both). Re-using Smath code (very simple - single line, single cell import), I get an error: " The 'br' start tag on line 767 does not match the end tag of 'front'. Line 768. position 9." Could you advise where I could start de-bugging / looking for a solution? Otherwise an awesome plug-in (until MS changed something ). Thanks and kind regards, Michael
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
I've made a survey on the Github of the plugin that handle the worksheets and seems something that might happens when a graph or an object contains multiline text, but cannot be fixed from inside that plugin. I might try to provide a fix from inside our plug-in; could you share the worksheet that cause the issue? (if cannot be published you can send me a PM or a mail). |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 21/10/2016(UTC) Posts: 84
Was thanked: 21 time(s) in 17 post(s)
|
I recognize some problems importing an excel-sheet. I use , as decimal point. If an excel sheet contains numbers with decimal point, importing fails. ( "The stack is empty." ) If I put a = before each number with point/comma, then it works. Changing the settings in Excel does not work. With the setting using point as 'decimal point" in Smath it works as in older versions. Please have a look at the screenshots below:
|
1 user thanked MarB for this useful post.
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Thank you very much, bug reproduced and hopefully fixed PLUGIN UPDATED |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 21/10/2016(UTC) Posts: 84
Was thanked: 21 time(s) in 17 post(s)
|
Originally Posted by: Davide Carpi Thank you very much, bug reproduced and hopefully fixed I am the one who has to thank you. It works.
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 24/01/2011(UTC) Posts: 8 Location: Волгоград
|
Good day, it is not possible to get data from the excel from cells B6 and E6. File excel attached my SMath XLSX input.xlsx (12kb) downloaded 52 time(s).
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
The problem here is that the I/O syntax of this plugin I've defined as the way to import/export symbolical data as the way to import/export math strings therefore you can't use excel string chaining, since it is interpreted as symbolic data. I guess that this feature is marginal enough to safely change it and set both the cases to import stuff as strings, then one can still use str2num() to convert to symbolic math, but I'm not sure about how this impact existing worksheets. Let's hear if someone in the community has some major concerns about this change. Edited by user 07 February 2018 16:24:10(UTC)
| Reason: Not specified |
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: Волгоград
|
I need to get the text data from the excel, which are generated by formulas ...
|
|
|
|
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 I need to get the text data from the excel, which are generated by formulas ... Ignore mycomment. In short, I don't understand why Excel is still delivered with Windows. My Win 7 laptop "Starter Edition" does not even have Word, Excel [Paint; piece of crap]. If you generate/tabulate data in Excel, it comes from formulas and cells referenced/dragged. You can generate same data in Smath. The attached will create CWD:="C:\SmathFile" to read from your download. Smath file system allows to save formulas [no limit], read them back ... an example given. text data ... you mean to read Excel numerical data <= back in Smath as Text, but why ? Maybe to make an image as frozen stuff for sharing ??? Smath 6179 File READ First.sm (23kb) downloaded 72 time(s).
|
1 user thanked Jean Giraud for this useful post.
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
PLUGIN UPDATED SMath Studio 0.99.6611 - All text cells are now imported as text (import of symbolic data still possible with built-in str2num() function); - Fixed import of empty strings; - Fixed import of some exponential numbers; Edited by user 12 February 2018 01:15:01(UTC)
| Reason: wrong target version |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
3 users thanked Davide Carpi for this useful post.
|
on 11/02/2018(UTC), on 11/02/2018(UTC), on 13/02/2018(UTC)
|
|
Rank: Newbie
Groups: Registered
Joined: 24/01/2011(UTC) Posts: 8 Location: Волгоград
|
Thanks, everything works well Edited by user 13 February 2018 11:06:04(UTC)
| Reason: Not specified
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 05/06/2018(UTC) Posts: 1
|
Hey. I have mistake. Not read cells with dual address. For example: 1. exit: import Data.XLSX (File_Data,"Source","X4","AH4" - does not import. 2. exit: importData.XLSX(File_Data,"Source","X4", "A4" - imports. That is, the difference in the address "A4" or " A4 " - with a double letter does not import. v. 1.1.6616.19995 source.7z (43kb) downloaded 37 time(s).Edited by user 05 June 2018 18:31:49(UTC)
| Reason: Not specified
|
|
|
|
Rank: Member Groups: Registered
Joined: 12/03/2013(UTC) Posts: 10
|
Hello, I found a failure with XLSX Import/Export plugin using in our national settings (Hungarian). We use "," as decimal symbol in Excel and in SMath too. If I export 5/4 or '0,8' to Excel, I'll get '0.8' (string). If I export 6/4, I'll get '2018.01.02' (date). If I import '="2.54*{'kN/'m}"' from Excel, I'll get '="2.54*{'kN/'m}"' (not '2,54 kN/m' . If I import '="2,54*{'kN/'m}"' from Excel, I'll get '="2,54*{'kN/'m}"'. But if I import '0,8' (number) from Excel, I'll get '0,8' value (wich is correct). Best regards Peter Kaderasz
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
Originally Posted by: chon Hey. I have mistake. Not read cells with dual address. For example: 1. exit: import Data.XLSX (File_Data,"Source","X4","AH4" - does not import. 2. exit: importData.XLSX(File_Data,"Source","X4", "A4" - imports. That is, the difference in the address "A4" or " A4 " - with a double letter does not import. v. 1.1.6616.19995 Sorry for the late answer, I've totally missed this report. When I open your file I see this: And if I change it with AH4 I get the result: I'll inspect the exeption thrown by AP4 however. Originally Posted by: kadpeter Hello, I found a failure with XLSX Import/Export plugin using in our national settings (Hungarian). We use "," as decimal symbol in Excel and in SMath too. If I export 5/4 or '0,8' to Excel, I'll get '0.8' (string). If I export 6/4, I'll get '2018.01.02' (date). If I import '="2.54*{'kN/'m}"' from Excel, I'll get '="2.54*{'kN/'m}"' (not '2,54 kN/m' . If I import '="2,54*{'kN/'m}"' from Excel, I'll get '="2,54*{'kN/'m}"'. But if I import '0,8' (number) from Excel, I'll get '0,8' value (wich is correct). Best regards Peter Kaderasz Hello, I'll inspect it ASAP (and if your able to provide a small file with these example it would help too ) |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Member Groups: Registered
Joined: 12/03/2013(UTC) Posts: 10
|
Hello Davide, I've tried the examples from the plugin's documentation ( https://en.smath.info/forum/yaf_postst1860_Xlsx-Import-Export-plugin.aspx). Here is a picture (this time I modified '4/5' to '6/5', you can see that this value imported to Excel as '2018.01.02' in our date format 'yyyy.mm.dd' :
Other numerical values, f.e. '-57,1' and 'sin(2^(1/2)) imported to Excel as string, so we can't do mathematical operations with these values. Best regards Peter Kaderasz Edited by moderator 23 October 2018 21:51:13(UTC)
| Reason: Not specified
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
PLUGIN UPDATED SMath Studio 0.99.6839 and later
- fixed export as text/date of numbers;release deletedEdited by user 24 October 2018 19:35:45(UTC)
| Reason: Not specified |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
PLUGIN UPDATED SMath Studio 0.99.6839 and later- fixed export as text/date of numbers;
- fixed previous commit issues on extension's download;
- migration to netstandard2.0/netcoreapp2.0
|
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,648 Location: Italy Was thanked: 1329 time(s) in 875 post(s)
|
PLUGIN UPDATED SMath Studio 0.99.6884 and later
Office Open XML I/O library changed from ClosedXML to EPPlusAdvantages: - better compatibility with non compliant xml schema (f.e. issues with newline in post #22 or here);
- smaller library size;
- works in SMath Viewer;
- easier coding;
Edited by user 23 November 2018 02:44:47(UTC)
| Reason: Not specified |
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects |
5 users thanked Davide Carpi for this useful post.
|
on 22/11/2018(UTC), on 22/11/2018(UTC), on 23/11/2018(UTC), on 23/11/2018(UTC), on 24/11/2018(UTC)
|
|
Rank: Newbie
Groups: Registered
Joined: 24/01/2011(UTC) Posts: 8 Location: Волгоград
|
Hello, stopped working import from xlsx file. lastError = " Variable and function names can't start with a number. File attached test.sm (8kb) downloaded 30 time(s).Edited by user 29 January 2019 08:13:53(UTC)
| Reason: Not specified
|
|
|
|
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.