[XlsxImportExport] Exporting Matrix into xlsm File

[XlsxImportExport] Exporting Matrix into xlsm File - Exporting a Matrix and exporting into xlsm file of excel - Messages

#21 Posted: 10/28/2018 5:53:31 AM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

Wrote

dont understand what you mean.



Wrote

If I use your first SMath Studio worksheet with the latest workbook it seems to work for me.



smath worksheet from post #1: Test_#1.sm (8 KiB) downloaded 24 time(s).
excel workbook from post #18: Wallthickness.xlsm (93 KiB) downloaded 28 time(s).

This works for me.

Wrote

In your latest worksheet
- first import function name ends with "M" instead of "X" in the subscript that is a function not defined


In post #18 you changed the content of the SMath worksheet.

2018-10-28 09_44_38-Window.png

This is the typo I was talking. As you correctly wrote in first post, it should be:
2018-10-28 09_46_26-Window.png

Wrote

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



2018-10-28 09_47_16-Window.png
This is the new range you are trying to import in the SMath worksheet #18. The range rewritten top-left:bottom-right is A5:G150. The plugin fails loading the first column (I see a circular reference exception in the debugger, thrown by the ClosedXML library), that is something I'll look into.
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#22 Posted: 10/28/2018 7:27:14 AM
Stefan Müller

Stefan Müller

0 likes in 45 posts.

Group: User

Thank you! Best regards!
  • New Posts New Posts
  • No New Posts No New Posts