Excel转换成XML文件(根据不同需求配制语句),本程序的特点是可以指定Excel的任一子表。(穷鬼求分,勿喷...)
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
using System.Data.OleDb;
using System.IO;
using System.Diagnostics;
using Excel = Microsoft.Office.Interop.Excel;
namespace WindowsApplication1
{
public partial class FormMain : Form
{
public FormMain()
{
InitializeComponent();
}
Microsoft.Office.Interop.Excel.Application obj;
Microsoft.Office.Interop.Excel.Workbook objWB;
private void buttonTransfer_Click(object sender, EventArgs e)
{
if (textBoxExcel.Text == string.Empty)
{
MessageBox.Show("还没指定Excel文件!", "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
textBoxExcel.Focus();
buttonOpenExcel.Focus();
}
else if (textBoxXml.Text == string.Empty)
{
MessageBox.Show("还没指定Xml文件保存路径!", "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
buttonSaveXml.Focus();
}
else if (comboBoxSheetName.SelectedIndex < -1 || comboBoxSheetName.Enabled == false)
{
MessageBox.Show("还没指定Excel中的Sheet!", "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
comboBoxSheetName.Focus();
}
else
{
Stopwatch sw