winform中,一个excel文件怎么取得它的每个sheet的名字(假设有sheet1……sheet5) insert into tablename SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=c:\excelfilename.xls;Extended properties=Excel 5.0')...[Sheet1$]中,[Sheet1$]的名字如何获得?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 只有想不到的,没有办不到的private bool GetExcelSheetName(ref string [] SheetName){ if (fileName == String.Empty) { return false; } StringBuilder sbTemp = new StringBuilder(); Excel.Application xslApp = new Excel.Application(); Excel.Workbooks xslWorkbooks =xslApp.Workbooks; Excel._Workbook xslWorkbook; try { xslWorkbook = xslApp.Workbooks.Add(fileName); xslApp.Visible = false; int sheetCount = xslWorkbook.Worksheets.Count; if (sheetCount == 0) { return false; } SheetName = new string[sheetCount]; Excel.Sheets xslSheets = xslWorkbook.Worksheets; for (int i = 1; i <= sheetCount; i ++) { Excel._Worksheet xslWorksheet= (Excel._Worksheet) xslSheets.get_Item(i); SheetName[i-1] = xslWorksheet.Name; } } catch(Exception ex) { MessageBox.Show(ex.Message); return false; } finally { xslWorkbooks.Close(); xslApp.Quit(); } return true;} 怎样在richTextBox中只接受0-9的数字输入 C#关于IC卡写卡的问题 向高手请教ActiveX控件打包部署的问题,请指教。 请高手帮忙解决 小问题 解决了马上给分 如何动态引用dll listview中的值做为查询条件 怎么在MAPX里面实现鼠标移动的时候画线 急~~~ 老大们,开发这样一个网站要多长时间啊? 能否不打开VS,就运行所有的单元测试并返回测试结果? 为什么我的继承窗体没有了设计视图? 现在用.net是否能实现无线上网的手机与电脑p2p通信
private bool GetExcelSheetName(ref string [] SheetName)
{
if (fileName == String.Empty)
{
return false;
} StringBuilder sbTemp = new StringBuilder();
Excel.Application xslApp = new Excel.Application();
Excel.Workbooks xslWorkbooks =xslApp.Workbooks;
Excel._Workbook xslWorkbook;
try
{
xslWorkbook = xslApp.Workbooks.Add(fileName);
xslApp.Visible = false; int sheetCount = xslWorkbook.Worksheets.Count;
if (sheetCount == 0)
{
return false;
} SheetName = new string[sheetCount];
Excel.Sheets xslSheets = xslWorkbook.Worksheets;
for (int i = 1; i <= sheetCount; i ++)
{
Excel._Worksheet xslWorksheet= (Excel._Worksheet) xslSheets.get_Item(i);
SheetName[i-1] = xslWorksheet.Name;
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
return false;
}
finally
{
xslWorkbooks.Close();
xslApp.Quit();
} return true;
}