C# splitting large excel file to smaller files

Question

I want to split one large Excel file to few smaller and accessible files.

I already tried to use this code but the files are not accessible:

using (System.IO.StreamReader sr = new System.IO.StreamReader("path"))
{
    int fileNumber = 0;

    while (!sr.EndOfStream)
    {
        int count = 0;

        using (System.IO.StreamWriter sw = new System.IO.StreamWriter("other path" + ++fileNumber + ".xlsx"))
        {
            sw.AutoFlush = true;

            while (!sr.EndOfStream && ++count < 20000)
            {
                sw.WriteLine(sr.ReadLine());
            }
        }
    }
}

Any ideas? thanks.

arbitrarily splitting a fie into chunks has purpose but what did you expect would be able to read it? excel has a format- if the format isnt valid it wont see it as a file.. — BugFinder
– BugFinder, Commented Sep 26, 2017 at 10:20
This is like trying to create two sedans out of a lorry, with only a saw. — nl-x
– nl-x, Commented Sep 26, 2017 at 10:23
It is do able with Aspose.Cells. But Aspose.Cells will read your original Excel file and create new Excel files for every portion or chunk of data. — shakeel
– shakeel, Commented Sep 27, 2017 at 14:16

ccalboni · Accepted Answer · 2017-09-26 10:20:54Z

1

Files, other than text files, don't work this way. You can't simply cut at a certain point and obtain a working copy.

As for Excel files, you may look into the following tutorial, which illustrates how to automate Excel from C#:

https://support.microsoft.com/en-us/help/302084/how-to-automate-microsoft-excel-from-microsoft-visual-c--net

Basically, what you want to do is open your large Excel file, decide where you want to split it (every n rows, every n sheets and so on), read each portion and write into a newly created xlsx.

answered Sep 26, 2017 at 10:20

ccalboni

12.6k5 gold badges33 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

C# splitting large excel file to smaller files

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related