topic RE: Not able to read excel file in collection in Product Forum

Not able to read excel file in collection

deepak_sachan — Tue, 31 Mar 2020 04:39:00 GMT

Hi ALL,

Blue prism in not able to read excel file that has 50000 Record .
Kindly suggest work around other than oledb because oledb is not working in my development server.

Regards
Deepak Sachan

------------------------------
Ericsson
Europe/London
------------------------------

RE: Not able to read excel file in collection

John__Carter — Tue, 31 Mar 2020 07:54:00 GMT

I'd be wary of reading a high spreadsheet in as a collection - likely you'll get memory issues. There are multiple possible OLEDB drivers for Excel - do you not have any available? At a push you could try uploading the data to a DB that you then query.

------------------------------
John Carter
Professional Services
Blue Prism
------------------------------

RE: Not able to read excel file in collection

Jens_OleKnudse1 — Wed, 01 Apr 2020 07:21:00 GMT

You can read parts of it, like 10.000 rows, and then add each read row to the collection.

Med venlig hilsen Jens Ole Knudsen Aktuar
Forca A/S	Tlf:	+45 39 45 73 00
Tuborg Boulevard 3	Direkte:	+45 39 45 43 57
DK - 2900 Hellerup	Mobil:	+45 21 60 35 70
https://www.forca.dk	E-mail:	jok@forca.dk



På vegne af vores pensionskunder servicerer Forca 600.000 danskere og har over 600 mia. kr. aktiver under administration. Vi står for medlems- og slutkundeservice, aktuarservice og analyse, fondsservice, it-service og økonomi- og regnskabsservice. Se, hvordan vi leverer skræddersyet stordrift gennem agilt samarbejde på https://www.forca.dk Pas på miljøet – udskriv kun denne e-mail hvis det er nødvendigt.

------Original Message------

Hi ALL,

Blue prism in not able to read excel file that has 50000 Record .
Kindly suggest work around other than oledb because oledb is not working in my development server.

Regards
Deepak Sachan

------------------------------
Ericsson
Europe/London
------------------------------