[XlsxImportExport] Exporting Matrix into xlsm File

[XlsxImportExport] Exporting Matrix into xlsm File - Exporting a Matrix and exporting into xlsm file of excel - Сообщения

#21 Опубликовано: 28.10.2018 05:53:31
Davide Carpi

Davide Carpi

1416 сообщений из 2873 понравились пользователям.

Группа: 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 КиБ) скачан 25 раз(а).
excel workbook from post #18: Wallthickness.xlsm (93 КиБ) скачан 29 раз(а).

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 Опубликовано: 28.10.2018 07:27:14
Stefan Müller

Stefan Müller

0 сообщений из 45 понравились пользователям.

Группа: User

Thank you! Best regards!
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений