现在我碰到一个问题是我的EXECL表格导出有问题,
private void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{
string FileName = saveFileDialog1.FileName;
outfilepath = FileName;
FileStream objFileStream;
StreamWriter objStreamWriter;
string strLine = "";
objFileStream = new FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write);
objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode);

for (int m = 0; m < dt.Columns.Count; m++)
{
strLine = strLine + dt.Columns[m].ColumnName.ToString() + Convert.ToChar(9);
}
objStreamWriter.WriteLine(strLine);
strLine = "";

for (int k = 0; k < dt.Rows.Count; k++)
{
//strLine = strLine + (k + 1) + Convert.ToChar(9);//添加序号列
for (int l = 0; l < dt.Columns.Count; l++)
{
strLine = strLine + dt.Rows[k][l].ToString()+ Convert.ToChar(9);
}
objStreamWriter.WriteLine(strLine);
strLine = "";
}
objStreamWriter.Close();
objFileStream.Close();

}
我是这样导出的,但是出来的文件格式是文本格式,不是EXCEL工作薄的格式,文本格式不是我想要的,我仍然需要microsoft office excel 工作薄的格式.该怎么解决呢,请各位前辈帮帮忙!

非常感谢您的支持,我已经尝试过上述的方法4,但是总是有错误这段代码运行出现以下错误,Exception from HRESULT: 0x800A03EC,我也不知道他用的是那个版本,是9.0还是,我用的是11.0的

有没有好消息!我现在真的是没有办法了,真是郁闷呀.郁闷!

呵呵!这个问题我解决了,是因为表的传输问题,问楼上的,你那个是不是速度特别慢呀?我这里简直是超慢!效率太低,写一个13*800=10400个单元格,估计要等个5分中左右才能做完,你那边的速度怎么样呀?

我已经经过改造,现在完全可以运行了,最近太忙了,没有时间来论坛,看到你这么认真我真的很感动,现在给你看:
public void saveFileDialog1_FileOk(object sender, CancelEventArgs e)
{

string FileName = saveFileDialog1.FileName;
long totalCount = dt.Rows.Count;
long totalCount1 = dt.Columns.Count;
long rowRead = 0;
int percent = 0;
Form6 frm = new Form6();
frm.Show();
Excel.Application xlApp = null;
xlApp = new Excel.Application();
Excel.Workbooks workbooks = xlApp.Workbooks;
Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[1];
//取得sheet1
Excel.Range range;
//写入字段
for (int i = 0; i < totalCount1; i++)
{
worksheet.Cells[1, i + 1] = dt.Columns[i].ColumnName;
range = (Excel.Range)worksheet.Cells[1, i + 1];
}
for (int r = 0; r < totalCount; r++)
{
for (int i = 0; i < totalCount1; i++)
{
worksheet.Cells[r+2,i+1]=dt.Rows[r][i];
if (i + 1 != totalCount1)
worksheet.Cells[r + 2, i + 2] = dt.Rows[r][i + 1];
}
rowRead++;
percent = (int)((100 * rowRead) / totalCount);
string info = "正在处理导出数据，已导出[" + percent.ToString("0.00") + "%]...";
frm.SetPersent(percent,info);
System.Windows.Forms.Application.DoEvents();
}
object cell1 = worksheet.Cells[2, 1];
object cell2 = worksheet.Cells[totalCount+ 1, totalCount1.Count];
range = worksheet.get_Range(cell1, cell2);

workbook.Saved = true;
workbook.SaveCopyAs(FileName);
}
这段是已经运行成功的!你看一下!

System.Data.DataTable dt=new System.Data.DataTable();
string FileName="d:\\abc.xls";
long totalCount=dt.Rows.Count;
因为我之前已经写好的一个表格,不需要System.Data.DataTable dt=new System.Data.DataTable();
有这一句的话,表格是空的,我想导出的表格没有传给public void saveFile(),所以一直有问题出现;谢谢大家的热心帮助!