Read excel with 1+ million rows using C#

prasad 1 Reputation point
2021-09-01T13:34:27.85+00:00

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#
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,521 questions
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,435 questions
{count} votes