Smalltalk › Frameworks & Tools › SciSmalltalk

[DataFrame] Reading data from XLSX file

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

5 messages Options

Francisco Lizarralde

[DataFrame] Reading data from XLSX file

Hi All,

I'm trying to read some data fron a XLSX file following this directive,

"3. Reading data from file

In most real-world scenarios the data is located in a file or database. The support for database connections will be added in future releases.

Right now DataFrame provides you the methods for loading data from two most commot file formats: CSV and XLSX

DataFrame fromCSV: 'path/to/your/file.csv'.
DataFrame fromXLSX: 'path/to/your/file.xlsx'."

but I don't find the XLSXImporter class.

Need I to load another package ?

Thanks in advance,

Best Rgeards,

Francisco

--
You received this message because you are subscribed to the Google Groups "SciSmalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.

Oleksandr Zaitsev

Re: [DataFrame] Reading data from XLSX file

Hello!

There is a missing dependency on the Tabular package. I have created an issue for it:

https://github.com/PolyMathOrg/DataFrame/issues/28

As a temporary solution, you can load Tabular from Catalog Browser.

Best regards,

Oleks

Francisco Lizarralde

Re: [DataFrame] Reading data from XLSX file

Hi Oleks,

Thank you very much for your reply. I'll try to load Tabular from Catalog Browser.

Best regards,

Francisco

2018-01-08 12:09 GMT-03:00 Oleksandr Zaytsev <[hidden email]>:

Hello!

There is a missing dependency on the Tabular package. I have created an issue for it:
https://github.com/PolyMathOrg/DataFrame/issues/28

As a temporary solution, you can load Tabular from Catalog Browser.

Best regards,
Oleks

--
You received this message because you are subscribed to a topic in the Google Groups "SciSmalltalk" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/scismalltalk/HWGEojfEh7s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.

SergeStinckwich

Re: [DataFrame] Reading data from XLSX file

The Tabular package has been had as a dependency now : https://github.com/PolyMathOrg/DataFrame/issues/28

On Mon, Jan 8, 2018 at 11:16 PM, Francisco Lizarralde <[hidden email]> wrote:

Hi Oleks,

Thank you very much for your reply. I'll try to load Tabular from Catalog Browser.

Best regards,

Francisco

2018-01-08 12:09 GMT-03:00 Oleksandr Zaytsev <[hidden email]>:
Hello!

There is a missing dependency on the Tabular package. I have created an issue for it:
https://github.com/PolyMathOrg/DataFrame/issues/28

As a temporary solution, you can load Tabular from Catalog Browser.

Best regards,
Oleks

--
You received this message because you are subscribed to a topic in the Google Groups "SciSmalltalk" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/scismalltalk/HWGEojfEh7s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "SciSmalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.

Serge Stinckwich
UMI UMMISCO 209 (IRD/UPMC/UY1)

"Programs must be written for people to read, and only incidentally for machines to execute."

http://www.doesnotunderstand.org/

Francisco Lizarralde

Re: [DataFrame] Reading data from XLSX file

In reply to this post by Oleksandr Zaitsev

Hi Oleks,

I wrote this method because I needed to load all worksheets present in a file

DATAFrame >> allWorksheetsFromXLSX: pathToFile

    | file workbook sheets |

    file := FileStream readOnlyFileNamed: pathToFile.
    workbook := XLSXImporter import: file.
    sheets := (workbook worksheets) collect: [ :sheet | self fromXLSXworksheet: sheet ].

    ^ sheets.

If you find it useful, it is my little contribution to DataFrame

Best regards,

Francisco

2018-01-08 12:09 GMT-03:00 Oleksandr Zaytsev <[hidden email]>:

Hello!

There is a missing dependency on the Tabular package. I have created an issue for it:
https://github.com/PolyMathOrg/DataFrame/issues/28

As a temporary solution, you can load Tabular from Catalog Browser.

Best regards,
Oleks

--
You received this message because you are subscribed to a topic in the Google Groups "SciSmalltalk" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/scismalltalk/HWGEojfEh7s/unsubscribe.
To unsubscribe from this group and all its topics, send an email to [hidden email].
For more options, visit https://groups.google.com/d/optout.