Create Tables to a New Workbook Based on Values in A Column

[marsaandari]

I have been trying to find a solution to this but seems to be stuck. Any kinds of insights or solutions would be very helpful!

Basically, I have an input file consist of multiple sheets that in each sheet contains some information such as “Name”, “Student ID”, and “Subject”.

My goal is to group them based on the “Subject” and then, export it to a new workbook, but with the same sheet names, and make it into different table for each Subject.

Here I have attached both the Input File AND the Expected Output File (My goal):
Expected_Output_File.xlsx (17.7 KB)
Input_File.xlsx (10.1 KB)

[ppr (Peter)]

@marsaandari
find starter help here:
GroupBy_1Col_AllSheets_SetGRMTables.xaml (18.3 KB)

it was producing following output:
OutPut.xlsx (12.3 KB)

In case of further development we would suggest to dele the output.excel during new runs. It will be created newly by the runs.

Also have a look here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operators Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start # All Operato…

[marsaandari]

Hi @ppr

When I tried to run it using different input file, I got this error: Create Table: Exception from HRESULT: 0x800A03EC in the midst of the process (not yet produced all the tables, just a few)

[marsaandari]

Hi @ppr

Just a little follow up. I have to give a little note that this new INPUT FILE that I have tried to use to run the program is way larger than the one I attached as a dummy data. Then, I tried to sort of minimalized the data I have in this new input file and it goes back to working fine. Therefore, I am guessing that the error might come out because of this large data that I have…

But the problem is I still couldn’t find the solution to this matter, cause in the future, I think I will have to keep using pretty large input file. Hope there is a solution that I can apply.

Thank you and regards

[ppr (Peter)]

@marsaandari
Just keep clear separated the two things:

• #1: your topic, about grouping and writing out to tables on Excel
• #2: the 0x800… issue

Let’s scope this topic on #1 by running with a smaller test set, but resembling all specifics from the data. So here we would suggest testing the provided XAML and checking if it is fitting to your case.

About #2:

• have a look here: Excel - How to deal with Exception from HRESULT: 0x800A03EC
• also do some searches on other topics

in case of the issue still occurs split it from this topic by opening a new topic scoped to the 0x800… case.

We suggest to scope topics to only one case as researchers can find more quickly their similar cases and their solutions. Thanks for support

[marsaandari]

Hi @ppr

Thank you!