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 Опубликовано: 20.09.2021 14:18:08
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.
#102 Опубликовано: 20.09.2021 16:14:43
Please try to update the plugin. Your version is from last year and is out of date.
Russia ☭ forever, Viacheslav N. Mezentsev
#103 Опубликовано: 20.09.2021 16:48:37
#104 Опубликовано: 20.09.2021 19:19:45
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 Опубликовано: 21.09.2021 11:29:09
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!
The issue is some bug in Office register.
Thank you for your compliments, Ricardo! Glad to see my videos are helping!
#106 Опубликовано: 21.09.2021 12:37:50
Thank you very much I have reinstalled office and now it works.
thanks for everyone's help.
A hug from a distance.
to all.
thanks for everyone's help.
A hug from a distance.
to all.
1 пользователям понравился этот пост
João Felipe Seráfico Melo 21.09.2021 14:48:00
#107 Опубликовано: 01.11.2021 08:46:47
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.
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 Опубликовано: 01.11.2021 10:05:32
Hello, good morning, could I send a screenshot to see the error that generates a hug from a distance
#109 Опубликовано: 10.11.2021 12:26:03
#110 Опубликовано: 11.11.2021 05:35:29
Plugin updated.
Changes:
- excel_in(): text encode issue fixed.
Russia ☭ forever, Viacheslav N. Mezentsev
2 пользователям понравился этот пост
#111 Опубликовано: 11.11.2021 08:57:18
Thank you very much, fixed with update 
#112 Опубликовано: 03.07.2022 04:18:14
Plugin updated.
Changes:
- added support for environment variables;
- refactored.
Russia ☭ forever, Viacheslav N. Mezentsev
1 пользователям понравился этот пост
Alvaro Diaz Falconi 03.07.2022 05:03:00
#113 Опубликовано: 03.07.2022 05:04:57
Plugin updated. ...
- added support for environment variables;
Hi Viacheslav. An example about what does that mean? Thanks.
Best regards.
Alvaro.
#114 Опубликовано: 03.07.2022 06:10:06
You can use operating system environment variables in the file path.
Russia ☭ forever, Viacheslav N. Mezentsev
4 пользователям понравился этот пост
NDTM Amarasekera 03.07.2022 08:00:00, churichuro 03.07.2022 12:59:00, Alvaro Diaz Falconi 03.07.2022 15:51:00, oscar mauricio 07.07.2022 11:37:00
#115 Опубликовано: 07.07.2022 11:54:58
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.
#116 Опубликовано: 08.07.2022 04:45:19
I found a problem in the excel_In() command. I present it in the image, I hope it can be resolved in future versions.
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).
Russia ☭ forever, Viacheslav N. Mezentsev
1 пользователям понравился этот пост
oscar mauricio 08.07.2022 16:00:00
#117 Опубликовано: 08.07.2022 07:01:35
It is possible to simplify the interface. I can add a new feature. You can suggest your own version for a new feature.
Russia ☭ forever, Viacheslav N. Mezentsev
#118 Опубликовано: 09.07.2022 06:43:56
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 пользователям понравился этот пост
#119 Опубликовано: 09.07.2022 12:41:31
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 11.07.2022 05:47:00
#120 Опубликовано: 12.07.2022 03:40:45
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.
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 15.07.2022 21:52:00
-
Новые сообщения
-
Нет новых сообщений