SMath Studio Forum
»
SMath Studio
»
Bugs & Problems
»
[XlsxImportExport] Exporting Matrix into xlsm File
Rank: Advanced Member Groups: Registered
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
Hey, hope the function to export a matrix into an excel with activated makro will work. Test.sm (9kb) downloaded 28 time(s). Wallthickness.xlsm (97kb) downloaded 27 time(s).It cannot save the file :-( lg Stefan
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
Seems a problem of the ClosedXML library when saving in the existing file... I'll check if can be solved in some way... Edited by user 20 October 2018 12:26:55(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
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
That would be great!!!!!!!!!!!! Thats at the moment my only problem since i always need a lot of makros in my excel file Best Regards Stefan from www.BHDT.at :-)
|
|
|
|
Rank: Member Groups: Registered
Joined: 22/10/2018(UTC) Posts: 22 Location: Saarbrücken
|
Hi, I still don´t get the way how to import xlsx files into SMath files. It seems, that the xlsx file is found, but there is an error, which sais my SMath file doesn´t exist. Would be happy about your help. Thanks. Regards G-Tate
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 28/08/2014(UTC) Posts: 1,361 Was thanked: 822 time(s) in 520 post(s)
|
Originally Posted by: G-Tate Hi,
I still don´t get the way how to import xlsx files into SMath files. It seems, that the xlsx file is found, but there is an error, which sais my SMath file doesn´t exist.
Hi Tate. The word unavaible "Page1" worksheet isn't about a SMath file, it's about a "Page1" worksheet in the "Excel workbook" named "SMath_Test" (without extension), which I guess that don't exist too (because the name of the Excel file requires the extension, not only the name). You can see examples about how to use the plugin here: https://en.smath.info/fo...mport-Export-plugin.aspxor directly here: https://en.smath.info/fo...urce.ashx?a=1772&b=2Best regards. Alvaro.
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
Try to add the ending to the filname .xlsx and check if Page1 exists
Seems to be that Page1 is not there in the file
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
If you don't give an extension xlsx is assumed as default; as pointed out by Alvaro and Stefan you have to check if the the worksheet exists in the file
excel workbook = the whole file excel worksheet = each single tab in the file |
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: 22/02/2014(UTC) Posts: 81
Was thanked: 11 time(s) in 10 post(s)
|
Hello Davide, The plugin doesn't work with the latest Smath beta. It crashes right away during plugin installation: I tried it in office on Win10 and at home on Win 7, all the same. I'm using 32-bit SS on 64-bit Windows.
|
1 user thanked tomtit for this useful post.
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
Thank you, confirmed. Latest release deleted. Edited by user 24 October 2018 19:33:48(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: Member Groups: Registered
Joined: 22/10/2018(UTC) Posts: 22 Location: Saarbrücken
|
Thank you very much guys! I didnt get, that the second name needs to be the sheet name from the excel workbook. I just tried it with the smath file name. I should´ve think about it, that the import anyway goes to the actual smath file. Best regards G-Tate
|
|
|
|
Rank: Advanced Member Groups: Registered
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
Could you solve the issue with the import/export of xlsm. Excel Files with Makro?
Best regards, Stefan
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
Might requires some time. I have to dig the GIT repo for the latest version of CLosedXML that supports .NET 3.5, inspect the code (not mine) and troubleshoot the bug (if possible). |
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: 26/06/2016(UTC) Posts: 45 Location: Styria
|
A ok i understand. I hope that would be possble in some time.
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
|
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,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
After a survey with the debugger, I found that the issue is known without clear solutions. The error message is: Exploring the xlsx archive I found a file named "vmlDrawing1" that contains the br tag (a newline tag in html format, should be a self-closing tag to make it compatible with the xml parsers); That is a button with this text: Code:Werkstoffdatenbank
öffnen
If you remove the neline character it should save correctly. Edited by user 25 October 2018 21:58:09(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
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
what you mean with removing the character?
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
Originally Posted by: soletto what you mean with removing the character? Edit the button text, replace newline with a space (go before the first character of the second word, backspace, then space) Edited by user 25 October 2018 22:11:14(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
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
No working :-( Now i cant import the loadcases row. Exporting into xlsm seems not working :-( Test.sm (7kb) downloaded 13 time(s). Wallthickness.xlsm (92kb) downloaded 14 time(s).lg Stefan Edited by user 26 October 2018 11:22:44(UTC)
| Reason: Not specified
|
|
|
|
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 13/01/2012(UTC) Posts: 2,653 Location: Italy Was thanked: 1340 time(s) in 879 post(s)
|
If I use your first SMath Studio worksheet with the latest workbook it seems to work for me. In your latest worksheet - first import function name ends with "M" instead of "X" in the subscript that is a function not defined - in second import the column A of the excel worksheet returns several circular reference exceptions (there aren't stored values even opening it with excel and the plugin isn't able to calculate one... I might return 0 or the cell formula...) Edited by user 26 October 2018 16:29:22(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
Joined: 26/06/2016(UTC) Posts: 45 Location: Styria
|
dont understand what you mean. I tried but nothing is working :-(
Does the Makro have an influence on the procedure?
|
|
|
|
SMath Studio Forum
»
SMath Studio
»
Bugs & Problems
»
[XlsxImportExport] Exporting Matrix into xlsm File
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.