C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,650 questions
Read excel with 1+ million rows using C#
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 37%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
prasad
1
Reputation point
Hi All,
I have a requirement to read the excel which has 1+ million rows and based on some column names inside the excel, i need it to write onto a pdf file.
when i have considered a windows desktop appln, seems, its not feasible.
so, thought of building the code using C# . console, which reads the excel from a file system loc.
But my question is whether how can i do this ? because it will take 24+ hrs to complete this activity even if if i assume, it will take 1 sec to read a row in excel and load in datatable and generate the pdf!
please help, whats the approach here.
C#
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,463 questions
{count} votes
-
Karen Payne MVP 35,386 Reputation points2021-09-01T14:00:49.15+00:00 Have you considered
- Using either SSMS to import Excel data into SQL-Server (any edition will do e.g. SQLEXPRESS for instance)
- Writing code in a console app to import Excel data into SQL-Server (any edition will do e.g. SQLEXPRESS for instance), could be executed via windows task scheduler off hours.
Microsoft Documentation to get started for above and this also.
If the above is not suitable, don't use Excel automation which will be slower than use OpenXML for Excel where there are libraries like EPPlus and SpreadSheetLight, both much faster than Excel automation. Unless you really need a DataTable consider creating a concrete class which represents data from a sheet or sheets as this also will speed things up.
Break out task
- Process Excel
- Generate PDF
Sign in to comment