Hello everyone!
I am running a process where i need to extract data table from webpage and write those data in Excel sheet.
But i got this error : Split or spanned archives are not supported. Why this error occurred ?
Till yesterday it was working fine. But Today it threw error.
Then try the above way to check first if you have issue across
If yes then rename the packages folder user .nuget folder in your user folder in C: and then reopen the project it downloads all the dependencies again
That the issue…may be the file is mal formed…youcan check that by opening the file in notepad…you can check the structure of a normal excel and this…
Now to handle this…try using parallel activity with click on ok on the left side and use excel on the right inside the parallel activity…in the condition add a boolean and set the boolean to true after the excel scope activity inside the parallel scope
I guess if you save the file using save as manually and then if you try to extract then you wont get the pop up as well
This excel file is stored in same folder where .xml files are stored.
Before extract table and storing in same excel. I have performed some actions to refine all xml inside that folder. In that process Excel was also process which was not to be.
Now, Everything goes well.
Bug is not good when arrived.
Bug is Good when solved.