Excel output processor

[rufuspollock]

Do we have one already? Where do I check this sort of stuff?

As a Developer I want to output the Data Package as an Excel file with each resource as a seperate tab so that I can share the excel file with people who use Excel

• Targetting modern Excel (xlsx)
• Bonus: output metadata in a separate sheet e.g. each resource with its metadata followed by 2 blank lines
• Bonus: metadata per resource as extra rows at the top of a sheet (?)

[Branko-Dj]

We don't have this option currently available.

To make it available I will add this functionality to already existing dump_to_path processor which currently supports only csv format so it can output the data and metadata in the separate sheets.

Current status of this can be found at https://github.com/datahq/dataflows/blob/master/PROCESSORS.md under dump_to_path. Once the coding is done I will update this file with instructions on how to use it and also the main TUTORIAL.md file with an example

[akariv]

Thanks, waiting for the PR :)

On Tue, Nov 20, 2018 at 10:38 AM Branko notifications@github.com wrote:

We don't have this option currently available.

To make it available I will add this functionality to already existing dump_to_path processor which currently supports only csv format so it can output the data and metadata in the separate sheets.

Current status of this can be found at https://github.com/datahq/dataflows/blob/master/PROCESSORS.md under dump_to_path. Once the coding is done I will update this file with instructions on how to use it and also the main TUTORIAL.md file with an example

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/datahq/dataflows/issues/47#issuecomment-440188331, or mute the thread https://github.com/notifications/unsubscribe-auth/AAQMdUDzzokZhidmftIuYVq7TP-BfzVqks5uw79zgaJpZM4YNRZ3 .

[OriHoch]

I wrote a basic implementation of this here: https://github.com/OriHoch/dataflows-xlsx

I'm hesitant about including it as part of core dataflows because it adds a big dependency on openpyxl and also I think that the processor is not as stable and consistent in usage as the core dump_to_path - e.g. it's not a standard tabular resource, can't load from it (only use the xlsx files directly) and excel itself is not a stable, well-define format.

[akariv]

Thanks @orihoch, that's awesome.

I'll review and reserve the right to fork it to the core organization :)

On Tue, Sep 24, 2019 at 10:18 AM Ori Hoch notifications@github.com wrote:

I wrote a basic implementation of this here: https://github.com/OriHoch/dataflows-xlsx

I'm hesitant about including it as part of core dataflows because it adds a big dependency on openpyxl and also I think that the processor is not as stable and consistent in usage as the core dump_to_path - e.g. it's not a standard tabular resource, can't load from it (only use the xlsx files directly) and excel itself is not a stable, well-define format.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/datahq/dataflows/issues/47?email_source=notifications&email_token=AACAY5MRKINFWQO35VZPGQDQLG5NHA5CNFSM4GBVCZ32YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD7NLEDI#issuecomment-534426125, or mute the thread https://github.com/notifications/unsubscribe-auth/AACAY5MHJZLFWYYBXLNHFKTQLG5NHANCNFSM4GBVCZ3Q .