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

Notification

Icon
Error

Login


3 Pages<123>
Options
Go to last post Go to first unread
Offline Davide Carpi  
#21 Posted : 17 April 2016 20:46:33(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: ElSid Go to Quoted Post
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
Offline MichaelSA  
#22 Posted : 27 August 2017 10:58:51(UTC)
MichaelSA

Rank: Newbie

Groups: Registered
Joined: 30/11/2015(UTC)
Posts: 1
South Africa
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 Sad ).

Thanks and kind regards,
Michael
Offline Davide Carpi  
#23 Posted : 27 August 2017 19:06:52(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)
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
Offline MarB  
#24 Posted : 29 January 2018 11:10:06(UTC)
MarB


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:

xlsx_1.PNGxlsx_2.PNG
thanks 1 user thanked MarB for this useful post.
on 29/01/2018(UTC)
Offline Davide Carpi  
#25 Posted : 29 January 2018 13:27:21(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)
Thank you very much, bug reproduced and hopefully fixed Good

PLUGIN UPDATED
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline MarB  
#26 Posted : 29 January 2018 14:41:17(UTC)
MarB


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 Go to Quoted Post
Thank you very much, bug reproduced and hopefully fixed Good


I am the one who has to thank you. It works.
Offline mikka  
#27 Posted : 07 February 2018 15:20:57(UTC)
mikka

Rank: Newbie

Groups: Registered
Joined: 24/01/2011(UTC)
Posts: 8
Man
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).
Offline Davide Carpi  
#28 Posted : 07 February 2018 16:16:29(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)
The problem here is that the I/O syntax of this plugin I've defined

Code:
="something"

as the way to import/export symbolical data

Code:
"something"

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
thanks 1 user thanked Davide Carpi for this useful post.
on 08/02/2018(UTC)
Offline mikka  
#29 Posted : 08 February 2018 08:31:06(UTC)
mikka

Rank: Newbie

Groups: Registered
Joined: 24/01/2011(UTC)
Posts: 8
Man
Location: Волгоград

I need to get the text data from the excel, which are generated by formulas ...
Offline Jean Giraud  
#30 Posted : 08 February 2018 19:05:01(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Originally Posted by: mikka Go to Quoted Post
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).
thanks 1 user thanked Jean Giraud for this useful post.
on 09/02/2018(UTC)
Offline Davide Carpi  
#31 Posted : 11 February 2018 22:10:11(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)
Beta PLUGIN UPDATED SMath Studio 0.99.6611 Beta

- 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
thanks 3 users thanked Davide Carpi for this useful post.
on 11/02/2018(UTC),  on 11/02/2018(UTC),  on 13/02/2018(UTC)
Offline mikka  
#32 Posted : 13 February 2018 10:05:02(UTC)
mikka

Rank: Newbie

Groups: Registered
Joined: 24/01/2011(UTC)
Posts: 8
Man
Location: Волгоград

Thanks, everything works well Good

Edited by user 13 February 2018 11:06:04(UTC)  | Reason: Not specified

Offline chon  
#33 Posted : 05 June 2018 18:15:49(UTC)
chon

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"Wink - does not import.
2. exit: importData.XLSX(File_Data,"Source","X4", "A4"Wink - 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

Offline kadpeter  
#34 Posted : 13 August 2018 13:48:29(UTC)
kadpeter


Rank: Member

Groups: Registered
Joined: 12/03/2013(UTC)
Posts: 10
Hungary

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'Wink.
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
Offline Davide Carpi  
#35 Posted : 13 August 2018 20:57:14(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: chon Go to Quoted Post
Hey. I have mistake. Not read cells with dual address.
For example:
1. exit: import Data.XLSX (File_Data,"Source","X4","AH4"Wink - does not import.
2. exit: importData.XLSX(File_Data,"Source","X4", "A4"Wink - 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:
2018-08-13 19_53_47-Window.png
And if I change it with AH4 I get the result:
2018-08-13 19_55_24-Window.png

I'll inspect the exeption thrown by AP4 however.

Originally Posted by: kadpeter Go to Quoted Post
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'Wink.
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 Good)
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline kadpeter  
#36 Posted : 15 August 2018 09:53:33(UTC)
kadpeter


Rank: Member

Groups: Registered
Joined: 12/03/2013(UTC)
Posts: 10
Hungary

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'Wink:



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

Offline Davide Carpi  
#37 Posted : 24 October 2018 01:32:06(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)
PLUGIN UPDATED SMath Studio 0.99.6839 and later

- fixed export as text/date of numbers;


release deleted

Edited 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
Offline Davide Carpi  
#38 Posted : 25 October 2018 19:09: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)
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
Offline Davide Carpi  
#39 Posted : 22 November 2018 20:27:36(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)
Beta PLUGIN UPDATED SMath Studio 0.99.6884 and later


Office Open XML I/O library changed from ClosedXML to EPPlus

Advantages:
  • 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
thanks 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)
Offline mikka  
#40 Posted : 29 January 2019 08:10:02(UTC)
mikka

Rank: Newbie

Groups: Registered
Joined: 24/01/2011(UTC)
Posts: 8
Man
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).
Snimok.JPG

Edited by user 29 January 2019 08:13:53(UTC)  | Reason: Not specified

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