Consume huge excel sheets by WCF Services
-
Hi, I need to write a WCF service to consume a large excel sheet (having in excess of 70,000 records). Bascially the client (a WPF Desktop application) needs to read the excel spreadsheet in a Data Set and perform validation against a schema. Once validated the client needs to send the data to the WCF service. The service then needs to insert the data in the database (simple inserts - one excel row becomes a row in the database table). What options (transport type and bindings) do I have for consuming the "huge" excel files EFFICIENTLY within the WCF Service?
Regards, Vipul Mehta
-
Hi, I need to write a WCF service to consume a large excel sheet (having in excess of 70,000 records). Bascially the client (a WPF Desktop application) needs to read the excel spreadsheet in a Data Set and perform validation against a schema. Once validated the client needs to send the data to the WCF service. The service then needs to insert the data in the database (simple inserts - one excel row becomes a row in the database table). What options (transport type and bindings) do I have for consuming the "huge" excel files EFFICIENTLY within the WCF Service?
Regards, Vipul Mehta
I use DataStreams http://www.csvreader.com/[^] It has to read the whole excel spreadsheet into memory first though but once done it is very simple and fast to read each row and do what you will with it.