Importing Excel spreadsheets - Djuggler web scraping and data integration software - Djuggler Forum - Default Group - Feature requests

Unanswered Active Topics

Forums Search

Forums > Default Group > Feature requests

Importing Excel spreadsheets

Last Post 12 May 2010 02:37 PM by Tom. 2 Replies.

Sort:

	Prev Next
Add Reply

Author

Messages

Tom

12 May 2010 11:24 AM
I think it would be a good feature to be able to import multiple Excel spreadsheets into a single datagrid. Currently importing them will overwrite whatever is currently already in there, instead of appending. Datagrid creation/naming being open to variables could act as a work around. I can't see any automated way to do this at the moment.

mazel

12 May 2010 12:43 PM
Hi Tom, Use a target grid and a buffer grid. Read xls's consecutively into the buffer grid, and use an Append Another Data Grid to append the data to the data already in TargetGrid. Use Clear Data Grid to clear the buffergrid and go to the next excel.

Tom

12 May 2010 02:37 PM
Thanks mazel, thats a great solution.

Add Reply

Forums > Default Group > Feature requests

Quick Reply

toggle

	Username:
	Subject:
	Body:
	Security Code:	Enter the code shown above:
Submit

Powered by Active Forums

	Forum participation and optional registration You don't need to be registered to partcipate in the Djuggler forums, however if you want to subscribe to email notifications you need to register. You can also subscribe to the forum RSS feed.