6 Pages«<456 Go to Page...

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  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

uni		#101 Posted : 20 September 2021 22:14:43(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		Please try to update the plugin. Your version is from last year and is out of date.
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
User Profile View All Posts by User View Thanks

Ricardo Herrera		#102 Posted : 20 September 2021 22:48:37(UTC)
Rank: Newbie Groups: Registered Joined: 04/08/2020(UTC) Posts: 8 Location: RicardoH Was thanked: 1 time(s) in 1 post(s)		XLSXupdate.txt (2kb) downloaded 20 time(s). Update plugin, but error persists. Keep holding Edited by user 20 September 2021 23:08:14(UTC)  | Reason: Not specified
		WWW
User Profile View All Posts by User View Thanks

uni		#103 Posted : 21 September 2021 01:19:45(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 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 Viacheslav N. Mezentsev
		BLOG Twitter
User Profile View All Posts by User View Thanks

joaobr		#104 Posted : 21 September 2021 17:29:09(UTC)
Rank: Advanced Member Groups: Registered Joined: 12/02/2018(UTC) Posts: 57 Location: Belém Was thanked: 6 time(s) in 5 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!
User Profile View All Posts by User View Thanks

Ricardo Herrera		#105 Posted : 21 September 2021 18:37:50(UTC)
Rank: Newbie Groups: Registered Joined: 04/08/2020(UTC) Posts: 8 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.
		WWW
1 user thanked Ricardo Herrera for this useful post.		on 21/09/2021(UTC)
User Profile View All Posts by User View Thanks

joaobr		#106 Posted : 01 November 2021 14:46:47(UTC)
Rank: Advanced Member Groups: Registered Joined: 12/02/2018(UTC) Posts: 57 Location: Belém Was thanked: 6 time(s) in 5 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
User Profile View All Posts by User View Thanks

Ricardo Herrera		#107 Posted : 01 November 2021 16:05:32(UTC)
Rank: Newbie Groups: Registered Joined: 04/08/2020(UTC) Posts: 8 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
		WWW
User Profile View All Posts by User View Thanks

MauroMen		#108 Posted : 10 November 2021 18:26:03(UTC)
Rank: Newbie Groups: Registered Joined: 20/11/2016(UTC) Posts: 7 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
User Profile View All Posts by User View Thanks

uni		#109 Posted : 11 November 2021 11:35:29(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		Plugin updated. Changes: - excel_in(): text encode issue fixed.
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
2 users thanked uni for this useful post.		on 11/11/2021(UTC),  on 11/11/2021(UTC)
User Profile View All Posts by User View Thanks

MauroMen		#110 Posted : 11 November 2021 14:57:18(UTC)
Rank: Newbie Groups: Registered Joined: 20/11/2016(UTC) Posts: 7 Location: Bogota Was thanked: 1 time(s) in 1 post(s)		Thank you very much, fixed with update
User Profile View All Posts by User View Thanks

uni		#111 Posted : 03 July 2022 10:18:14(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		Plugin updated. Changes: - added support for environment variables; - refactored.
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
1 user thanked uni for this useful post.		on 03/07/2022(UTC)
User Profile View All Posts by User View Thanks

Razonar		#112 Posted : 03 July 2022 11:04:57(UTC)
Rank: Advanced Member Groups: Registered Joined: 28/08/2014(UTC) Posts: 998 Was thanked: 548 time(s) in 357 post(s)		Originally Posted by: uni Plugin updated. ... - added support for environment variables; Hi Viacheslav. An example about what does that mean? Thanks. Best regards. Alvaro.
User Profile View All Posts by User View Thanks

uni		#113 Posted : 03 July 2022 12:10:06(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		You can use operating system environment variables in the file path.
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
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)
User Profile View All Posts by User View Thanks

MauroMen		#114 Posted : 07 July 2022 17:54:58(UTC)
Rank: Newbie Groups: Registered Joined: 20/11/2016(UTC) Posts: 7 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.
User Profile View All Posts by User View Thanks

uni		#115 Posted : 08 July 2022 10:45:19(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		Originally Posted by: MauroMen 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). Edited by user 08 July 2022 10:49:41(UTC)  | Reason: Not specified
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
1 user thanked uni for this useful post.		on 08/07/2022(UTC)
User Profile View All Posts by User View Thanks

uni		#116 Posted : 08 July 2022 13:01:35(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 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. Edited by user 08 July 2022 13:22:10(UTC)  | Reason: Not specified
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
User Profile View All Posts by User View Thanks

uni		#117 Posted : 09 July 2022 12:43:56(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		In a future release I will remove functions from ExcelIOCom to XLSXupdate. One function and one operand will be added. Edited by user 09 July 2022 16:26:10(UTC)  | Reason: Not specified
		Russia ☭ forever Viacheslav N. Mezentsev
		BLOG Twitter
2 users thanked uni for this useful post.		on 09/07/2022(UTC),  on 09/07/2022(UTC)
User Profile View All Posts by User View Thanks

uni		#118 Posted : 09 July 2022 18:41:31(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 post(s)		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
		BLOG Twitter
1 user thanked uni for this useful post.		on 11/07/2022(UTC)
User Profile View All Posts by User View Thanks

uni		#119 Posted : 12 July 2022 09:40:45(UTC)
Rank: Advanced Member Groups: Registered, Advanced Member Joined: 10/11/2010(UTC) Posts: 1,324 Was thanked: 1157 time(s) in 668 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 Viacheslav N. Mezentsev
		BLOG Twitter
1 user thanked uni for this useful post.		on 16/07/2022(UTC)
User Profile View All Posts by User View Thanks

Users browsing this topic

6 Pages«<456 Go to Page...