Open multiple worksheets from same import settings

[adelhommeau]

First, thanks for this asset.

Then, as a request, is it possible to load different sheets or files with the same import setting?
I work with Excel for the data and I have multiple files that contain multiple worksheets with all the same data construction.
So I don't want to create one different asset for each worksheet, I need to create a bunch of the same asset containing data from each asset.
I tried to copy an asset and modify sheetName and workSheetName but it seems it can't be changed (static readonly).
Is there a way to achieve this?

Thanks.
Antoine.

[kimsama]

Hey,
Sorry for the delayed reply.

The quick answer would be NO. Sorry for that. The quicksheet was not created minding with that point.
When I write the project, I would want to keep it as simple as it can be. If your use case is quite a big one, the quicksheet would not be an ideal one but you may want to use something like database with SQL support.

For multiple files, you may need any other way to merge a couple of worksheet onto one file. You would find with a googling a proper way.

So I don't want to create one different asset for each worksheet, I need to create a bunch of the same asset containing data from each asset.

What exactly does it mean? Would you give some details or an example about this? What is your use case?

Cheers,

[adelhommeau]

Probably nothing due to my english...
I have several .xlsx containing data of the same class.
I want to create an asset for each .xlsx without duplicating classes, import settings, or else.

I understood that I have to create a different class (which would be all the same) with different import settings (i.e. just modifying the .xlsx filename).
Or
Concatenate all in one .xlsx, import the data and then create my own system that generates multiple assets from it. (Which I did).

At this time, my problem is solved by a workaround.
Before that, I was wondering if this was possible or if this could be achieved.
THX