Xlsx Import/Export plugin

Xlsx Import/Export plugin - share data between SMath Studio and XLSX spreadsheets - 消息

#41 已发布: 2019/1/29 04:55:41
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

It is something in the workbook content, can't say much more without the file
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#42 已发布: 2019/1/29 08:37:16
Mikka

Mikka

36个赞,共206个帖子。

组: User

Here is the file to import
Iskh_dannye.zip (25.32 KiB)已下载 681 次。
Не официальный справочник http://sites.google.com/site/mikkhalichlab/ jabber конференция smath@conference.jabber.ru
#43 已发布: 2019/1/29 09:40:22
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

I cannot reproduce the issue; please try if with the new beta you get more informations from the error message.
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
1位用户喜欢此帖子
Mikka 2019/1/29 09:59:00
#44 已发布: 2019/1/29 09:58:33
Mikka

Mikka

36个赞,共206个帖子。

组: User

The new beta version is working, thank you!
Не официальный справочник http://sites.google.com/site/mikkhalichlab/ jabber конференция smath@conference.jabber.ru
#45 已发布: 2019/1/29 10:25:52
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

Wrote

File attached


Excel file not attached !
#46 已发布: 2019/4/18 10:08:19
Mo

Mo

0个赞,共34个帖子。

组: User

Hi,
I was using this great plugin and found that sometimes it does weird thing.
for instance, it gave an error and I had to re-write the import/export expression to make it work again.
but now I am stuck with something that I don't understand why it is happening, when I want to read from cell K11 the result is 1.01 instead of 0.86
trying other cells will give correct results except K11 will not return the correct value.

Thanks!!

Another point, in the attached file, I am using both import and export functions, when I update any variable in my SMath sheet, the results in Excel is updated but the results in SMath do not change (the import function does not refresh and if I manually refresh it, still I am stuck with old values), why?
未找到文件。 未找到文件。


Temp.zip (8.96 KiB)已下载 627 次。
#47 已发布: 2019/4/18 11:23:30
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: User

Wrote

Hi,
I was using this great plugin and found that sometimes it does weird thing.
for instance, it gave an error and I had to re-write the import/export expression to make it work again.



It works for me. Close Excel file and Recalculate the SMath file.
SMath displays an error if Excel file is open.

Ledger Calcs.jpg
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
#48 已发布: 2019/4/18 19:21:19
Mo

Mo

0个赞,共34个帖子。

组: User

It worked when I closed both Excell and Smath and opened SMath again.
but the problem now, is when I change the inputs, say ts=22mm the output (calculated value from excel) does not update, which is essential in a sheet like that.
#49 已发布: 2019/4/18 23:46:11
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: User

Wrote

but the problem now, is when I change the inputs, say ts=22mm the output (calculated value from excel) does not update, which is essential in a sheet like that



Hi Mido0,

Yes you are correct.
Sorry for my earlier feedback.
Hope some one may be able to help.
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
#50 已发布: 2019/4/19 08:40:19
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

I'll check what I can do but the backbone of this plugin is the indipendence from excel (is not required nor used at all). You can get and set data inside xlsx files even in hostile environments, f.e. when MS excel isn't available because another program is installed or none is available at all. The possibility of performing calculations before getting the data or after saving it is probably possible, but isn't made by excel; this means that some functions might be missing and probably you should double-check the result.

To perform calculations on the fly inside excel the right plugin is this: EXCEL (2003+) I/O with recalculation and export to PNG
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#51 已发布: 2019/11/16 15:33:17
KhasanMamaev

KhasanMamaev

3个赞,共5个帖子。

组: User

Импорт информации из Excel
Import from Excel
2位用户喜欢此帖子
Davide Carpi 2019/11/16 19:55:00, Serg 2020/4/29 02:37:00
#52 已发布: 2021/2/21 14:25:04
goha

goha

0个赞,共1个帖子。

组: User

Please help me, if you can.
I have a problem when importing numbers with units of measurement.
Using SMath Studio Desktop v 0.99 build 7610 with XlsxImportExport 1.3.6996.39330
When I try to import a number with units of measurement from xlsx document, like for example: 2300 * {'kg *' m} / {'s ^ 2} in SMath Studio, I get string variable as a result: "2300 * {' kg * 'm} / {' s ^ 2} ".
How can I get number with units of measurement type variable, like this image1.png
Source document: my SMath XLSX input.xlsx
Screenshot_1.jpg
Example, before recalculation:
Screenshot_2.jpg
Example, after recalculation:
Screenshot_3.jpg
Software versions:
Screenshot_4.jpg
Screenshot_5.jpg
#53 已发布: 2021/2/21 14:35:14
Alvaro

Alvaro

1,139个赞,共1,805个帖子。

组: User

Hi. You can try to apply this algorithm, and see if you are satisfied with its result:

Clipboard01.jpg

Best regards.
Alvaro.
  • 有新帖
  • 无新帖