来自第八行的inport excel文件 [英] inport excel file from eighth row

问题描述

我有一张excel表。在前七行包含图像。第八行我有一个数据头。和第九行以后我有数据。如何读取第八行中的数据。在asp.net c＃

解决方案

你可以提供范围和表名。

  string  SheetName = dtExcelSchema.Rows [ 0 ] [  TABLE_NAME]。ToString（）; 
 cmdExcel.CommandText =   SELECT * From [ + SheetName +   A9：F25]; 
 da.SelectCommand = cmdExcel; 
 da.Fill（ds）; 
 connExcel.Close（）; 

可以使用MicMicrosoft.Office.Interop.Excel解决。



1.添加COM参考，Microsoft Excel 14.0对象库，添加使用Excel = MicMicrosoft.Office.Interop.Excel;



2.以下是在a.xls中读取A8：B21范围内数据的示例，工作表名称为Sheet1

  var  app =  new  Excel.Application（）; 
 Excel.Workbook workBook = app.Workbooks.Open（ @  C：\ Users \Administrator \\ \\Documents\a.xls）; 
 Excel.Sheets sheets = workBook.Worksheets; 
 Excel.Worksheet datasheet =  null ; 
  foreach （Excel.Worksheet表 表）
 {
  if （sheet.Name ==   Sheet1）
 {
 datasheet = sheet; 
  break ; 
} 
} 
 
 如果（ null  = = datasheet）
  return ; 
 
  object  [，]  var  = datasheet.get_Range（  A9，  B21）的get_value（Excel.XlRangeValueDataType.xlRangeValueDefault）。 
 
  for （ int  i =  1 ; i <  =  var  .GetLength（ 0 ）; ++ i）
 {
  for （ int  j =  1 ; j <  =  var  .GetLength（ 1 ）; ++ j）
 {
 Console.Write（（ double ） var  [i，j] +  ）; 
} 
 Console.WriteLine（）; 
} 
 workBook.Close（）; 

I have one excel sheet. in that first seven rows contains images. eighth row i have a data header . and nitnth row onwards i have data. how to read data in eighth row. in asp.net c#

解决方案

You can provide range along with sheetname.

string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString();
cmdExcel.CommandText = "SELECT * From [" + SheetName + "A9:F25]";
da.SelectCommand = cmdExcel;
da.Fill(ds);
connExcel.Close();

It can be solved with "MicMicrosoft.Office.Interop.Excel".

1. Add the COM reference, "Microsoft Excel 14.0 Object Library", add "using Excel = MicMicrosoft.Office.Interop.Excel;"

2. Here is an example for reading data in the range "A8:B21" in "a.xls", and the sheet name is "Sheet1"

var app = new Excel.Application();
Excel.Workbook workBook = app.Workbooks.Open(@"C:\Users\Administrator\Documents\a.xls");
Excel.Sheets sheets = workBook.Worksheets;
Excel.Worksheet datasheet = null;
foreach (Excel.Worksheet sheet in sheets)
{
    if (sheet.Name == "Sheet1")
    {
        datasheet = sheet;
        break;
    }
}

if (null == datasheet)
    return;

object[,] var = datasheet.get_Range("A9", "B21").get_Value(Excel.XlRangeValueDataType.xlRangeValueDefault);

for (int i = 1; i <= var.GetLength(0); ++i)
{
    for (int j = 1; j <= var.GetLength(1); ++j)
    {
        Console.Write((double)var[i, j] + " ");
    }
    Console.WriteLine();
}
workBook.Close();            

这篇关于来自第八行的inport excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！