Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error
7 Pages«<4567>
Fixed EXCEL (2003+) I/O with recalculation and export to PNG - Uses EXCEL PIA (2003+) to import/export data to and from XLS/XLSX files
Options
Go to last post Go to first unread
Previous Topic Next Topic
Offline uni  
#101 Posted : 20 September 2021 22:14:43(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
Please try to update the plugin. Your version is from last year and is out of date.
Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
Offline Ricardo Herrera  
#102 Posted : 20 September 2021 22:48:37(UTC)
Ricardo Herrera

Rank: Newbie

Groups: Registered
Joined: 04/08/2020(UTC)
Posts: 8
Peru
Location: RicardoH

Was thanked: 1 time(s) in 1 post(s)
XLSXupdate.txt (2kb) downloaded 26 time(s).
Update plugin, but error persists.
Keep holding

Edited by user 20 September 2021 23:08:14(UTC)  | Reason: Not specified
Back to top
WWW
Offline uni  
#103 Posted : 21 September 2021 01:19:45(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
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:
Code:
Excel HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)
Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
Offline joaobr  
#104 Posted : 21 September 2021 17:29:09(UTC)
joaobr


Rank: Advanced Member

Groups: Registered
Joined: 12/02/2018(UTC)
Posts: 62
Man
Brazil
Location: Belém

Was thanked: 7 time(s) in 6 post(s)
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!
Back to top
Offline Ricardo Herrera  
#105 Posted : 21 September 2021 18:37:50(UTC)
Ricardo Herrera

Rank: Newbie

Groups: Registered
Joined: 04/08/2020(UTC)
Posts: 8
Peru
Location: RicardoH

Was thanked: 1 time(s) in 1 post(s)
Thank you very much I have reinstalled office and now it works.
thanks for everyone's help.
A hug from a distance.
to all.
Back to top
WWW
thanks 1 user thanked Ricardo Herrera for this useful post.
on 21/09/2021(UTC)
Offline joaobr  
#106 Posted : 01 November 2021 14:46:47(UTC)
joaobr


Rank: Advanced Member

Groups: Registered
Joined: 12/02/2018(UTC)
Posts: 62
Man
Brazil
Location: Belém

Was thanked: 7 time(s) in 6 post(s)
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.

Edited by user 01 November 2021 15:47:34(UTC)  | Reason: Not specified
Back to top
Offline Ricardo Herrera  
#107 Posted : 01 November 2021 16:05:32(UTC)
Ricardo Herrera

Rank: Newbie

Groups: Registered
Joined: 04/08/2020(UTC)
Posts: 8
Peru
Location: RicardoH

Was thanked: 1 time(s) in 1 post(s)
Hello, good morning, could I send a screenshot to see the error that generates a hug from a distance
Back to top
WWW
Offline MauroMen  
#108 Posted : 10 November 2021 18:26:03(UTC)
MauroMen


Rank: Member

Groups: Registered
Joined: 20/11/2016(UTC)
Posts: 10
Man
Colombia
Location: Bogota

Was thanked: 1 time(s) in 1 post(s)
Hi, I have the same problem as Ricardo, any recommendations to solve it?

Edited by moderator 03 July 2022 10:48:26(UTC)  | Reason: Not specified
Back to top
Offline uni  
#109 Posted : 11 November 2021 11:35:29(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
SMath Studio compatibility

Plugin updated.

Changes:

- excel_in(): text encode issue fixed.
Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 2 users thanked uni for this useful post.
on 11/11/2021(UTC),  on 11/11/2021(UTC)
Offline MauroMen  
#110 Posted : 11 November 2021 14:57:18(UTC)
MauroMen


Rank: Member

Groups: Registered
Joined: 20/11/2016(UTC)
Posts: 10
Man
Colombia
Location: Bogota

Was thanked: 1 time(s) in 1 post(s)
Thank you very much, fixed with update Good
Back to top
Offline uni  
#111 Posted : 03 July 2022 10:18:14(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
SMath Studio compatibility

Plugin updated.

Changes:

- added support for environment variables;
- refactored.
Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 1 user thanked uni for this useful post.
on 03/07/2022(UTC)
Online Razonar  
#112 Posted : 03 July 2022 11:04:57(UTC)
Razonar


Rank: Advanced Member

Groups: Registered
Joined: 28/08/2014(UTC)
Posts: 1,473
Uruguay

Was thanked: 925 time(s) in 588 post(s)
Originally Posted by: uni Go to Quoted Post

Plugin updated. ...

- added support for environment variables;

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

Best regards.
Alvaro.
Back to top
Offline uni  
#113 Posted : 03 July 2022 12:10:06(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
You can use operating system environment variables in the file path.

XLSXupdate.jpg
Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 4 users thanked uni for this useful post.
on 03/07/2022(UTC),  on 03/07/2022(UTC),  on 03/07/2022(UTC),  on 07/07/2022(UTC)
Offline MauroMen  
#114 Posted : 07 July 2022 17:54:58(UTC)
MauroMen


Rank: Member

Groups: Registered
Joined: 20/11/2016(UTC)
Posts: 10
Man
Colombia
Location: Bogota

Was thanked: 1 time(s) in 1 post(s)
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
Back to top
Offline uni  
#115 Posted : 08 July 2022 10:45:19(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
Originally Posted by: MauroMen Go to Quoted Post
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

Edited by user 08 July 2022 10:49:41(UTC)  | Reason: Not specified

Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 1 user thanked uni for this useful post.
on 08/07/2022(UTC)
Offline uni  
#116 Posted : 08 July 2022 13:01:35(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
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

Edited by user 08 July 2022 13:22:10(UTC)  | Reason: Not specified

Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
Offline uni  
#117 Posted : 09 July 2022 12:43:56(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
In a future release I will remove functions from ExcelIOCom to XLSXupdate. One function and one operand will be added.

XLSXupdate. excel.jpg XLSXupdate. External reference.jpg

Edited by user 09 July 2022 16:26:10(UTC)  | Reason: Not specified

Russia ☭ forever (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 2 users thanked uni for this useful post.
on 09/07/2022(UTC),  on 09/07/2022(UTC)
Offline uni  
#118 Posted : 09 July 2022 18:41:31(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
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 (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 1 user thanked uni for this useful post.
on 11/07/2022(UTC)
Offline uni  
#119 Posted : 12 July 2022 09:40:45(UTC)
uni


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 10/11/2010(UTC)
Posts: 1,619
Man
Russian Federation

Was thanked: 1382 time(s) in 806 post(s)
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 (git.io/vOZo0)
Viacheslav N. Mezentsev
Back to top
BLOG Twitter
thanks 1 user thanked uni for this useful post.
on 16/07/2022(UTC)
Offline Alex M.  
#120 Posted : 14 November 2022 21:29:27(UTC)
Alex M.


Rank: Advanced Member

Groups: Registered
Joined: 03/03/2014(UTC)
Posts: 418
Canada

Was thanked: 125 time(s) in 96 post(s)
Originally Posted by: uni Go to Quoted Post
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
Back to top
Users browsing this topic
7 Pages«<4567>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET