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.
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)
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.
@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.