Search results

  1. S

    How to read data from excel having 1000 colums using OLEDB.

    Hi all, We have a requirement to read data from excel having 1001 colums. Due to large excel data (7k rows and1001 cols) we are using oledb to retrieve only filtered records into bp collection (max of 10 records) but as OLEDB has a limitation of getting only first 255 cols. Request you to...
  2. S

    System out of memory exception when getting excel data even on using OLEDB

    I have a requirement to identify first empty column out of the filtered records. Excel 1= 7k rows and 1k columns Upon applying filter criteria it will be max of 3 to 4 rows with 1000 columns. For 1 employee If am not able to find empty columns for filtered records(3 to 4) from excel 1 then...
    • SriLakshmi
    • Thread
    • from excel into bp collection how to get more than 255 columns more column data oledb
    • Replies: 0
    • Forum: Blue Prism
  3. S

    How to find a value in data table using c# in blueprism

    Hi All, I have 8 different excels and each with 7k rows and 1000 columns I want to find a employee id in all excels and get all the column names where this employee id is available. Ex: employee id might be available 0 or any number of times in any cell in any excel. Points to be noted:. 1. In...
Top