Wrote

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.

Hello Uni,

It has been years since I have touched this plugin. Thank you for keeping it up to date and expanding its functionality! I use this plugin close to daily. I intend to add couple function calls to work with EXCEL Macro and perhaps a region to display the EXCEL range (so that Image Region plugin is not needed).

What do I need to know so that I do not interfere with useful changes you have made?

Cheers

Sasha

Wrote

What do I need to know so that I do not interfere with useful changes you have made?

You can use Initialize() and GetTermsHandled() methods to add your features as before. If you add code and do not remove what is there, then there should be no problems. If problems arise, I will help to resolve them.

Reading only 0s using excel_OUT()

For those in Canada, My Windows 10 had a "," separator that prevented the plug-in to read the data in Excel.
The bug appeared when I decided to change the data format to numbers to have one decimal precision.
It was showing only 0s.
Changing the "," with a "." in the regional Windows setting was successful. Still showing "," in excel.
Great plugin
Thanks

Wrote

Reading only 0s using excel_OUT()

For those in Canada, My Windows 10 had a "," separator that prevented the plug-in to read the data in Excel.
The bug appeared when I decided to change the data format to numbers to have one decimal precision.
It was showing only 0s.
Changing the "," with a "." in the regional Windows setting was successful. Still showing "," in excel.
Great plugin
Thanks

it's a known occurrence - I had difficulty incorporating regional settings into the plugin