Excel Extension

Interested adding compiled externals from LiveCode and third parties to your LiveCode projects? This is the place to talk about them.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
ecann
Posts: 327
Joined: Wed Oct 26, 2016 12:26 pm

Excel Extension

Post by ecann » Sat Aug 15, 2020 4:02 pm

Hello everyone,

Please I want to know if the free version of the excel extension and the paid version are made by the same developer. If yes what are the limitations of the free version and how different is it from the paid version

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9249
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: Excel Extension

Post by richmond62 » Sat Aug 15, 2020 4:27 pm

Which Excel extension would that be?

Personally I export comma-delimited text files from spreadsheets and then import them into table fields.

Of course one of the reasons I do that is because I wouldn't be seen dead using Microsoft Office, preferring to use Open Office
or LibreOffice.

bn
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3975
Joined: Sun Jan 07, 2007 9:12 pm
Location: Bochum, Germany

Re: Excel Extension

Post by bn » Sat Aug 15, 2020 7:18 pm

have a look at the site of the author

this is probably the one you want:
https://www.aslugontheroad.com/ourprodu ... r-livecode

I can not figure out what the difference between the opensource and paid version is.
Maybe just email Zyrip (email on the website)

Kind regards
Bernd
Last edited by bn on Sat Aug 15, 2020 8:40 pm, edited 1 time in total.

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9249
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: Excel Extension

Post by richmond62 » Sat Aug 15, 2020 8:38 pm

I can not figure out what the difference between the opesource and paid version is.
Maybe just email Zyrip (email on the website)
'opesource' ?

Well, considering the grammar is ALL wrong on that web page I wouldn't take that $199
very seriously.

bn
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 3975
Joined: Sun Jan 07, 2007 9:12 pm
Location: Bochum, Germany

Re: Excel Extension

Post by bn » Sat Aug 15, 2020 8:47 pm

richmond62 wrote:
Sat Aug 15, 2020 8:38 pm
I can not figure out what the difference between the opesource and paid version is.
Maybe just email Zyrip (email on the website)
'opesource' ?
Now corrected.
Well, considering the grammar is ALL wrong on that web page I wouldn't take that $199
very seriously.
Zyrip's native language is French, so forgive him. May I also ask for clemency? My native language is German.

Kind regards
Bernd

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9249
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: Excel Extension

Post by richmond62 » Sat Aug 15, 2020 9:07 pm

Ce n'est pas un problem pour moi, mais ce ne pas clair sur le site à
propos le difference entre le version libre et . . . 8)

And, as English is NOT my native language (although, because of "l'Empire des Anglais" . . . )
I do sometimes jalouse at their language.

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 163
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: Excel Extension

Post by Zryip TheSlug » Wed Aug 26, 2020 6:36 pm

Thanks a lot Richmond, for the kindness of your remarks.
This is always a pleasure to be part of a tolerant community.

Fortunately, with the Bernd's help, Emmanuel contacted me directly by email with his question, because I'm not reading the forum very often.
And oddly, more I'm coming here, less I want to stay and participate.

very seriously

Anyway, I have nothing to share and I am no one, so this is not a great lose.

Now excuse me, I have some grammar to check on my website. See ya next decade!


P.S. Thanks Bernd ;)

Kind Regards,
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

Zryip TheSlug
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 163
Joined: Tue Jan 26, 2010 10:15 pm
Contact:

Re: Excel Extension

Post by Zryip TheSlug » Sat Aug 29, 2020 10:05 am

An update to my previous post, because I have really the bad feeling that Richmond is trying to burn all the work provided on this Library.

What would be the relation between the fact that someone is not able to express itself correctly, and the quality of his work?
Why reduce the Excel Lib to just a way to import comma delimited file?

This Lib has been thought to automate repetitive tasks done with Excel.
In this purpose, we have commands of different scopes.
Some of them allow to create worksheets and graphs from scratch. Others, are built for looking for a value, a comment and are returning the corresponding cells ranges.
We have also commands to create pivot tables, and link them to a SQL database.
We have commands to style cells and create professional documents.
We have commands to create formulae.
Etc.

Imagine you have a scientific mesure device which is creating a file describing a process implicating components.
With the Excel Lib, you can extract exactly all the data you need and create a new workbook, with one worksheet by component, and in this worksheet, one graphic to resume the data.

You have different salesman all around the world, each one sending you an xlsx file?
You can extract specific sheets, columns and rows in the file and consolidate the data in the way you want.


So, the Excel Lib is not just something replacing the import of a comma delimited file, and makes free money, as this is suggest.

It comes with about 200 commands. All, are described in a documentation containing interactive examples.
The Lib works on Mac and Windows.

The commercial version includes:
1. my support. This support is, the author:
- helping you building your project
- creating specific new commands for you on your request
- maintaining the Lib and its documentation all over the years. Because LiveCode changes. Because MS Excel changes. Because the Lib itself is improved on needs.
2. An alpha of another Lib capable of a part of what the main Lib is doing, but this time without to have the need of MS Excel installed, so compatible with libreoffice or other xlsx tool.
3. Full examples with code you can copy-paste in your project, such as a tool to import an xlsx file in a displayer. Another one to demonstrate how to consolidate data from a datagrid to an Excel Lib.

So all of this have been taken time to create, to test, to optimize. And we provide serious support to our customers (see our reviews on the LiveCode Store). Whatever our way to communicate or whatever our grammar is at this time.

This is alway easy for random people to come and try to freely launch affirmations with NO arguments and expect to destroy what the other people are doing. Just for fun? Just because they are feeling themselves clever than others?
richmond62 wrote:
Sat Aug 15, 2020 8:38 pm
Well, considering the grammar is ALL wrong on that web page I wouldn't take that $199
very seriously.
It would have been easy to email me or send me a private message warning me my page contains mistakes, instead of trying to discredit my work in a forum, by using an easy suggestive sophism (the grammar is bad so the tool is worth nothing). Richmond, where is the "very serious" of this rhetoric argument?


Best Regards,
Last edited by Zryip TheSlug on Sat Aug 29, 2020 10:47 am, edited 1 time in total.
TheSlug
http://www.aslugontheroad.com - Tutorials, demo stacks and plugins for LiveCode
Data Grid Helper - An intuitive interface for building LiveCode's Data Grids
Excel Library- Extends the LiveCode language for controlling MS Excel

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9249
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: Excel Extension

Post by richmond62 » Sat Aug 29, 2020 10:11 am

Indeed, you are quite right.

Pelase (sic) [serves me right] accept my apologies.
Last edited by richmond62 on Sat Aug 29, 2020 8:04 pm, edited 1 time in total.

jacque
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 7210
Joined: Sat Apr 08, 2006 8:31 pm
Location: Minneapolis MN
Contact:

Re: Excel Extension

Post by jacque » Sat Aug 29, 2020 7:13 pm

richmond62 wrote:
Sat Aug 29, 2020 10:11 am
Indeed, you are quite right.

Pelase accept my apologies.
@slug: Given the spelling error, I wouldn't take Richmond's remarks too seriously. :)

I'm not sure if it was intentional or not but it did make me smile.
Jacqueline Landman Gay | jacque at hyperactivesw dot com
HyperActive Software | http://www.hyperactivesw.com

Post Reply

Return to “Using Externals”