Excel parser handle regular expression sheet name

BCODMO / frictionless-usecases

Example datasets submitted to BCO-DMO

MIT License

2 stars 0 forks source link

Excel parser handle regular expression sheet name #23

Closed cschloer closed 5 years ago

cschloer commented 5 years ago

Currently you can only load one excel sheet at a time with the xls/xlsx parser. It would be great if you could load multiple resources at a time by entering a regular expression for the sheet name. For example * would load all of the sheets.

My suggestion would be that if the name parameter is blank, each resource is named after the sheet name. A nice addition would be the ability to input a string of comma separated names into the name parameter that will match up with the resources captured by the regular expression (assuming the sheets are loaded in the order that they show on a normal excel reader).

Thanks for all of your work!

cschloer commented 5 years ago

Hey @roll is it okay if I reorder the priority on the OKF Pilot board? The top three (https://github.com/BCODMO/frictionless-usecases/issues/21 , https://github.com/BCODMO/frictionless-usecases/issues/18 and https://github.com/BCODMO/frictionless-usecases/issues/17) are pretty low prioity for us.

roll commented 5 years ago

@cschloer sure, please do

roll commented 5 years ago

@cschloer @adyork So the current situation with this one:

the solution was developed by me and it works - https://github.com/datahq/dataflows/pull/110
it will not be accepted because it can be really ineffective for remote files due to how tabulator works (and I agree that it's more like a hack - the solution is not general enough)

So we can do regarding BCO-DMO:

using the written code in the custom BCO-DMO processor (it works fine for local data sources)
using preprocessor (within UI code I guess) proposed here - https://github.com/datahq/dataflows/pull/110#issuecomment-535501938 - creating needed load steps automatically

cschloer commented 5 years ago

:+1: thanks @roll !