EXCEL (2003+) I/O with recalculation and export to PNG

EXCEL (2003+) I/O with recalculation and export to PNG - Uses EXCEL PIA (2003+) to import/export data to and from XLS/XLSX files - 消息

#101 已发布: 2021/9/20 14:18:08
Ricardo_Herrera

Ricardo_Herrera

1个赞,共8个帖子。

组: User

引用

XLSXupdate.txt (1.81 KiB)已下载 1383 次。

first it is a great surprise is to be able to greet his person.
Thank you very much for your time. and by Smath Studio. Thank you very much for what you teach and what you do.
Rikardo21
#102 已发布: 2021/9/20 16:14:43
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

Please try to update the plugin. Your version is from last year and is out of date.
Russia ☭ forever, Viacheslav N. Mezentsev
#103 已发布: 2021/9/20 16:48:37
Ricardo_Herrera

Ricardo_Herrera

1个赞,共8个帖子。

组: User

XLSXupdate.txt (1.85 KiB)已下载 1422 次。
Update plugin, but error persists.
Keep holding
Rikardo21
#104 已发布: 2021/9/20 19:19:45
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

This problem appears due to the presence of old keys in the registry, which will contain the wrong path to Excel. Try to search in Google for a solution to your problem using the error text from the log file:
Excel HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)
Russia ☭ forever, Viacheslav N. Mezentsev
#105 已发布: 2021/9/21 11:29:09
João Felipe Seráfico Melo

João Felipe Seráfico Melo

7个赞,共62个帖子。

组: User

Ricardo, I updated the plugin and made a Quick Repair in my Office 365, restarted the pc and now it works perfectly.
The issue is some bug in Office register.

Thank you for your compliments, Ricardo! Glad to see my videos are helping!
#106 已发布: 2021/9/21 12:37:50
Ricardo_Herrera

Ricardo_Herrera

1个赞,共8个帖子。

组: User

Thank you very much I have reinstalled office and now it works.
thanks for everyone's help.
A hug from a distance.
to all.
Rikardo21
1位用户喜欢此帖子
João Felipe Seráfico Melo 2021/9/21 14:48:00
#107 已发布: 2021/11/1 08:46:47
João Felipe Seráfico Melo

João Felipe Seráfico Melo

7个赞,共62个帖子。

组: User

Hi! I'm having trouble sending String variables to Excel.

For instance, ". - / ! ? ;" turns into \002E\\0020\\002D\\0020\\002F\\0020\\0021\\0020\\003F\\0020\\003B\ in Excel.

I'm using most recent SMath and Excel I/O versions.
#108 已发布: 2021/11/1 10:05:32
Ricardo_Herrera

Ricardo_Herrera

1个赞,共8个帖子。

组: User

Hello, good morning, could I send a screenshot to see the error that generates a hug from a distance
Rikardo21
#109 已发布: 2021/11/10 12:26:03
oscar mauricio

oscar mauricio

1个赞,共10个帖子。

组: User

Hi, I have the same problem as Ricardo, any recommendations to solve it?

显示剧透

#110 已发布: 2021/11/11 05:35:29
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

SMath Studio compatibility

Plugin updated.

Changes:

- excel_in(): text encode issue fixed.
Russia ☭ forever, Viacheslav N. Mezentsev
2位用户喜欢此帖子
João Felipe Seráfico Melo 2021/11/11 08:48:00, oscar mauricio 2021/11/11 08:49:00
#111 已发布: 2021/11/11 08:57:18
oscar mauricio

oscar mauricio

1个赞,共10个帖子。

组: User

Thank you very much, fixed with update
#112 已发布: 2022/7/3 04:18:14
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

SMath Studio compatibility

Plugin updated.

Changes:

- added support for environment variables;
- refactored.
Russia ☭ forever, Viacheslav N. Mezentsev
1位用户喜欢此帖子
Alvaro 2022/7/3 05:03:00
#113 已发布: 2022/7/3 05:04:57
Alvaro

Alvaro

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

组: User

Wrote


Plugin updated. ...

- added support for environment variables;


Hi Viacheslav. An example about what does that mean? Thanks.

Best regards.
Alvaro.
#114 已发布: 2022/7/3 06:10:06
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

You can use operating system environment variables in the file path.

XLSXupdate.jpg
Russia ☭ forever, Viacheslav N. Mezentsev
4位用户喜欢此帖子
NDTM Amarasekera 2022/7/3 08:00:00, churichuro 2022/7/3 12:59:00, Alvaro 2022/7/3 15:51:00, oscar mauricio 2022/7/7 11:37:00
#115 已发布: 2022/7/7 11:54:58
oscar mauricio

oscar mauricio

1个赞,共10个帖子。

组: User

Hello thanks for the plugin, I found a problem in the excel_In() command. I present it in the image, I hope it can be resolved in future versions.

220707_8595_lite.png
#116 已发布: 2022/7/8 04:45:19
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

Wrote

I found a problem in the excel_In() command. I present it in the image, I hope it can be resolved in future versions.



SMath Studio compatibility

Plugin updated. Please try.

Changes:

- ToCell(): Globals.Excel.DecimalSeparator replaced by the CultureInfo.GetCultureInfo( "en-EN" ).NumberFormat.NumberDecimalSeparator;
- ToCell(): Double.Parse() fixed;
- part of the book "Excel 2002 VBA Programmer's Reference" added (Chapter 22. International Issues).

Click to enlarge
Russia ☭ forever, Viacheslav N. Mezentsev
1位用户喜欢此帖子
oscar mauricio 2022/7/8 16:00:00
#117 已发布: 2022/7/8 07:01:35
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

It is possible to simplify the interface. I can add a new feature. You can suggest your own version for a new feature.

XLSXupdate. excel function.jpg
Russia ☭ forever, Viacheslav N. Mezentsev
#118 已发布: 2022/7/9 06:43:56
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

In a future release I will remove functions from ExcelIOCom to XLSXupdate. One function and one operand will be added.

未找到文件。 未找到文件。
Russia ☭ forever, Viacheslav N. Mezentsev
2位用户喜欢此帖子
churichuro 2022/7/9 11:09:00, sergio 2022/7/9 11:20:00
#119 已发布: 2022/7/9 12:41:31
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

SMath Studio compatibility Examples

Plugin updated. Please try.

Changes:

- excel operand and excel() function added;
- readCell() and writeCell() moved from the ExcelIOCom plugin;
- examples added;
- refactored.
Russia ☭ forever, Viacheslav N. Mezentsev
1位用户喜欢此帖子
sergio 2022/7/11 05:47:00
#120 已发布: 2022/7/12 03:40:45
Вячеслав Мезенцев

Вячеслав Мезенцев

1,558个赞,共1,868个帖子。

组: Moderator

There are several ways to work with Excel documents. I can add support for ClosedXML and EPPlus. In this case I will rename the plugin to Excel Toolbox. The choice of how to work with Excel can be done using a variable:

excel:="driver:COM" or excel:="driver:EPPlus" or excel:="driver:ClosedXML"

Each of the drivers provides its own capabilities. It is possible to try to implement other features, such as:

- create books, add and delete sheets;
- accessing named ranges;
- ...

I could change the language used in the plugin (VB.NET), but decided to leave it as an example of development in this language. This introduces some problems, but they are solvable.
Russia ☭ forever, Viacheslav N. Mezentsev
1位用户喜欢此帖子
oscar mauricio 2022/7/15 21:52:00
  • 有新帖
  • 无新帖