thank you for the feedback


best regards,

Davide

Examples added to the first post (XlsxImportExport_docs.7z - nothing changes in the usage from those contained in the previous Data Exchange plugin)

Attached here a pdf to show the expected output.


regards,

w3b5urf3r

Edited by user 10 June 2013 14:01:49(UTC)  | Reason: Not specified

I tried this plugin out, since importing and exporting to excel would be extremely useful.

However when I try to import a cell with a function referencing another cell, the cell reference is imported (eg: A5*G4), instead of the value of the cell. Is there any way around this?

Also, is it possible to export to an existing excel file, without overwriting it? I tried exporting to an existing file, and everything in the file gets erased, except for the newly exported data.


Thanks,

Ernesto.

Edited by user 03 February 2014 08:42:55(UTC)  | Reason: Not specified

In the example file it is stated


Does this mean if the file is in the same folder as SMath?

It appears that the program looks where the Smath.exe file is stored is that correct?
Thanks

EDIT:

I wanted to use the folder where the calulcation page and the excel sheet was stored. Therefore I should first set CurrentDirectory(DocumentDirectory("")

Edited by user 06 April 2014 16:54:15(UTC)  | Reason: Not specified

Is the Excel import meant to be Viewer-safe? I get the attached error message if I try to run a viewer application with excel read. With ods-format the situation is similar.

I try to setup a data browser for use by my colleagues, therefore any hints on how to do viewer-safe data import of spreadsheets are welcome. Perhaps this could be done within excel, but I am not comfortable with it and just use the opportunity to do some SMath testing.

Davide,

The issue with "DocumentFormat.OpenXml.dll" not found when you create and run an .exe can be resolved by removing the reference to the .dll from the "References" section in your extention solution. You do not call this .dll anywhere in the extension so it is not needed. When I do this, I no longer get the missing .dll error.

The .exe still does not pull in the Excel spreadsheets I want with the missing .dll error fixed. I did do further investigation and the .exe program can not handle even a simple mat() function by itself with no other references. This lead me to believe that the .exe program is at issue and not your extension.

Mike

I figured this conversation is best to be continued here



Is it possible to run visual basic script from your plugin? I have come up with (pieced together from numerous online sources) a .vbs file that will update (in background) all the XLSX files in the directory it is run from (it will actually run a background EXCEL process that can be tasked to do anything excel can). If this or similar could be incorporated in your plugin I can see following happening:

1. Modify "input" xlsx workbook using your data exchange plugin
2. Run .vbs script that will recalculate/save all workbooks linked to input work book (I wonder if it is possible to somehow start the sript from within Smath)
3. Export cell range from desired workbook

I am sure with .vbs there is a way to perform all input - calculations - output strictly in memory, so no files need to be saved unless desired. I am not sure, however, if it is something that can be used by a Smath Studio plugin.

Best regards

Edited by user 11 March 2015 22:37:13(UTC)  | Reason: Not specified

PLUGIN UPDATED SMath Studio 0.97.5737

• importData.XLSX() can access files opened by other processes (only saved data);

Edited by user 20 January 2016 19:34:50(UTC)  | Reason: Not specified

Does this or any other "excel" plugin work with "ods" extensions? I am on Libre office on both Windows and Linux at home. I could not get to work.