Reading excel file having 433 columns

Question

1.00/5 (1 vote)

See more:

Hi All,

I am building an application whish is converting .xlsx file to .csv file.An excel file contains 433 column but while converting its only taking 255 columns.Please provide me the solution by which i can read more than 255 columns.

Posted 14-Dec-11 23:59pm

richa11

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jitendra Parida - Jeetu · Answer 1 · 2011-12-15T21:01:00

Hi,

use this modified code working fine.

C#

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0}; Extended Properties=""Excel 12.0;HDR=No;IMEX=1""", fpath);
        OleDbConnection conn = null;
        StreamWriter wrtr = null;
        OleDbCommand cmd = null;
        OleDbDataAdapter da = null;
       
            conn = new OleDbConnection(connectionString);
            conn.Open();
            cmd = new OleDbCommand("SELECT * FROM [test$]", conn);
            cmd.CommandType = CommandType.Text;
            wrtr = new StreamWriter("D:\\test.csv");

            da = new OleDbDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);


            string rowString = ""; ;
            for (int x = 0; x < dt.Rows.Count; x++)
            {
               
                rowString = "";
                for (int y = 0; y < dt.Columns.Count; y++)
                {
                    rowString += "\"" + dt.Rows[x][y].ToString() + "\",";   
                }
                wrtr.Write(rowString);
            }
            string str = rowString;
            wrtr.Dispose();
            conn.Close();
            MessageBox.Show("file is saved");

richa11 · Answer 2 · 2011-12-15T00:18:00

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0}; Extended Properties=""Excel 12.0;HDR=No;IMEX=1""", fpath);
OleDbConnection conn = null;
StreamWriter wrtr = null;
OleDbCommand cmd = null;
OleDbDataAdapter da = null;
try
{
conn = new OleDbConnection(connectionString);
conn.Open();
cmd = new OleDbCommand("SELECT * FROM [test$]", conn);
cmd.CommandType = CommandType.Text;
wrtr = new StreamWriter("D:\\test.csv");

da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

for (int x = 0; x < dt.Rows.Count; x++)
{

string rowString = "";
for (int y = 0; y < dt.Columns.Count; y++)
{
rowString += "\"" + dt.Rows[x][y].ToString() + "\",";

}
wrtr.WriteLine(rowString);
}
conn.Close();
MessageBox.Show("file is saved");

This is my code to convert the file

Jitendra Parida - Jeetu · Answer 3 · 2011-12-15T00:17:00

Solution 2

Hi,

Please tell us what is the process to follow you convert to excel file to cvs file.
if are you convert though code then you can put for loop for read data on excel file and insert data on cvs file and make some millisecond time difference to continue the loop.

if any problem show me your code!!

Posted 15-Dec-11 0:17am

Jitendra Parida - Jeetu

Updated 15-Dec-11 0:18am

v2

Comments

richa11 15-Dec-11 6:23am

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source={0}; Extended Properties=""Excel 12.0;HDR=No;IMEX=1""", fpath);
OleDbConnection conn = null;
StreamWriter wrtr = null;
OleDbCommand cmd = null;
OleDbDataAdapter da = null;
try
{
conn = new OleDbConnection(connectionString);
conn.Open();
cmd = new OleDbCommand("SELECT * FROM [test$]", conn);
cmd.CommandType = CommandType.Text;
wrtr = new StreamWriter("D:\\test.csv");

da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

for (int x = 0; x < dt.Rows.Count; x++)
{

string rowString = "";
for (int y = 0; y < dt.Columns.Count; y++)
{
rowString += "\"" + dt.Rows[x][y].ToString() + "\",";

}
wrtr.WriteLine(rowString);
}
conn.Close();
MessageBox.Show("file is saved");

This is my code to convert the file
Improve solution Permalink | Posted 3 mins ago

bolivankit · Answer 4 · 2011-12-15T00:10:00

Solution 1

try using range in the select query for reading the excel file.

Please do provide the right solution, if this doesn't work

Posted 15-Dec-11 0:10am

bolivankit

Reading excel file having 433 columns

4 solutions

Solution 4

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0