string myStrFileName1 = DateTime.Now.AddDays(0).ToString("MM");
int sheet;
sheet = Convert.ToInt32(myStrFileName1);
Microsoft.Office.Interop.Excel.Application excel2 = new Microsoft.Office.Interop.Excel.Application();
Excel.Workbook workbook1 = excel2.Workbooks._Open(@"D:\预警、重要报告、通报\副本巴市回归.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Excel.Sheets objSheets;
Excel._Worksheet objSheet;
Excel._Worksheet objSheet1;
Excel.Range range;//=new Range[100];
Excel.Range range1;//=new Range[100];
string[,] tdyb = new string[100, 100];
int[,] tgyb=new int [100,100];
int[,] tyb = new int[100, 100];
string[,] tgdyb = new string[100, 100]; objSheets = excel2.Worksheets;
objSheet = (Excel._Worksheet)objSheets.get_Item(sheet);
range = objSheet.get_Range("A1", "IT34");
// range1 = objSheet1.get_Range("A1", "GN32");
object[,] saRet1 = (System.Object[,])range.get_Value(Missing.Value);
//object[,] saRet11 = (System.Object[,])range1.get_Value(Missing.Value);
//MessageBox.Show(Convert.ToString(saRet1[2, 1]));
int iii = 6;
string my = DateTime.Now.AddDays(0).ToString("dd");
int intld = 14, intcells1 = 7;
for (int i2 = 1; i2 <= 3; i2++)
{
for (int i1 = 1; i1 <= 9; i1++)
{ tdyb[i2, i1] = Convert.ToString(saRet1[Convert.ToInt32(my) + i2 + 2, intld]);
tgdyb[i2, i1] = Convert.ToString(saRet1[Convert.ToInt32(my) + i2 + 2, intld+14]);
tgyb[i2, i1] = Convert.ToInt32(tdyb[i2, i1]);
tyb[i2, i1] = Convert.ToInt32(tgdyb[i2, i1]);
intld = intld + 28;
}
intld = 14; }
tgyb[i2, i1] = Convert.ToInt32(tdyb[i2, i1]);
这一行出问题了,我读的都是数字,不知道为啥出问题,
错误为:将一个字符串转换为data time时,应先分析该字符串以获日期,然后将每个变量放到data time变量中
int sheet;
sheet = Convert.ToInt32(myStrFileName1);
Microsoft.Office.Interop.Excel.Application excel2 = new Microsoft.Office.Interop.Excel.Application();
Excel.Workbook workbook1 = excel2.Workbooks._Open(@"D:\预警、重要报告、通报\副本巴市回归.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value
, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
Excel.Sheets objSheets;
Excel._Worksheet objSheet;
Excel._Worksheet objSheet1;
Excel.Range range;//=new Range[100];
Excel.Range range1;//=new Range[100];
string[,] tdyb = new string[100, 100];
int[,] tgyb=new int [100,100];
int[,] tyb = new int[100, 100];
string[,] tgdyb = new string[100, 100]; objSheets = excel2.Worksheets;
objSheet = (Excel._Worksheet)objSheets.get_Item(sheet);
range = objSheet.get_Range("A1", "IT34");
// range1 = objSheet1.get_Range("A1", "GN32");
object[,] saRet1 = (System.Object[,])range.get_Value(Missing.Value);
//object[,] saRet11 = (System.Object[,])range1.get_Value(Missing.Value);
//MessageBox.Show(Convert.ToString(saRet1[2, 1]));
int iii = 6;
string my = DateTime.Now.AddDays(0).ToString("dd");
int intld = 14, intcells1 = 7;
for (int i2 = 1; i2 <= 3; i2++)
{
for (int i1 = 1; i1 <= 9; i1++)
{ tdyb[i2, i1] = Convert.ToString(saRet1[Convert.ToInt32(my) + i2 + 2, intld]);
tgdyb[i2, i1] = Convert.ToString(saRet1[Convert.ToInt32(my) + i2 + 2, intld+14]);
tgyb[i2, i1] = Convert.ToInt32(tdyb[i2, i1]);
tyb[i2, i1] = Convert.ToInt32(tgdyb[i2, i1]);
intld = intld + 28;
}
intld = 14; }
tgyb[i2, i1] = Convert.ToInt32(tdyb[i2, i1]);
这一行出问题了,我读的都是数字,不知道为啥出问题,
错误为:将一个字符串转换为data time时,应先分析该字符串以获日期,然后将每个变量放到data time变量中
解决方案 »
- 复选框的问题
- crystal report如何判断此笔数据为本页的第一笔资料?
- 菜鸟咨询个DataView的查询问题
- 如何将类型“object”显示转换为“Microsoft.Win32.RegistryKey”(在线等!)
- 一个通信方面的思路问题
- sql语句问题,请高手帮忙
- 請問如何對datagrid中資料改變顏色?
- Double数值比较问题
- SetUp Factory 7.0如何把WINFORM的.net Framework 2.0和access打包进去?
- 用户控件能否在全局范围使用?
- 如何在超链接中传值<script type="text/javascript"> function open1() {
- 请明白人给讲一讲
你是尝试转换成Int,奇怪为什么要报DateTime的错误。
先看看这个值的格式 ,然后看是否转换异常。