Wrote

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

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

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).

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:

File not found.File not found.

Thank you very much, bug reproduced and hopefully fixed

PLUGIN UPDATED

Wrote

Thank you very much, bug reproduced and hopefully fixed

I am the one who has to thank you. It works.

Good day, it is not possible to get data from the excel from cells B6 and E6. File excel attachedmy SMath XLSX input.xlsx (11 KiB) downloaded 91 time(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.

I need to get the text data from the excel, which are generated by formulas ...

Wrote

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 (22 KiB) downloaded 124 time(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;

Thanks, everything works well

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 (42 KiB) downloaded 80 time(s).

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

Wrote

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.

Wrote

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 )

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

Show Spoiler

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

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

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;

Hello, stopped working import from xlsx file.
lastError = " Variable and function names can't start with a number. File attached

test.sm (7 KiB) downloaded 77 time(s).