private void GetExcel()
{
string Path = Server.MapPath("Scripts/micr.xls");
Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();
object missing = Missing.Value;
Microsoft.Office.Interop.Excel.Workbooks workBooks = excelApplication.Workbooks;
Microsoft.Office.Interop.Excel.Workbook workBook = workBooks.Add(Path);
Microsoft.Office.Interop.Excel.Sheets sheets = workBook.Worksheets;
Microsoft.Office.Interop.Excel.Worksheet workSheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
DataSet ds = new DataSet();
string strConn = ("Provider=Microsoft.Jet.OleDb.4.0;" + "data source=") + Path + ";Extended Properties=Excel 8.0;";
using (OleDbConnection Conn = new OleDbConnection(strConn))
{
Conn.Open();
string strSql = "Select * From [Sheet1$]";
OleDbCommand Cmd = new OleDbCommand(strSql, Conn);
OleDbDataAdapter sqlada = new OleDbDataAdapter();
sqlada.SelectCommand = Cmd;
sqlada.Fill(ds);
Conn.Close();
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i == 0)
{
string aa = ds.Tables[0].Rows[i][0].ToString();
workSheet.Cells[i + 1, 9] = "";
workSheet.Columns.AutoFit();
Microsoft.Office.Interop.Excel.Range rang = workSheet.get_Range((object)workSheet.Cells[i+1, 9], (object)workSheet.Cells[i+1, 9]);
}
else
{
string aa = ds.Tables[0].Rows[i][0].ToString();
workSheet.Cells[i + 1, 9] = "false";
workSheet.Columns.AutoFit();
Microsoft.Office.Interop.Excel.Range rang = workSheet.get_Range((object)workSheet.Cells[i + 1, 9], (object)workSheet.Cells[i + 1, 9]);
}
}
string homePath = @"C:\Documents and Settings\a507394\Desktop\123.xls";
workBook.SaveAs(homePath, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
}
读取EXCEL内容
最新推荐文章于 2023-12-09 10:48:04 发布