static void Main(string[] args)
{
DataSet ds = null;
XlsxFileReader reader = new XlsxFileReader();
reader.ProgressPercentChanged += reader_ProgressPercentChanged;
reader.DateTimeDataColumnName.Add("时间");
ds = reader.Read("t1.xlsx", true);
if (ds != null)
{
DataTable dt = ds.Tables[0];
DataRow dr = dt.Rows[8];
for (int i = 0; i != dr.ItemArray.Length; i++)
{
Console.WriteLine("[" + dt.TableName + "].(" + dt.Columns[i].ColumnName + " : " + dr.ItemArray[i] + ")");
}
}
Console.WriteLine("Reading Over!");
XlsxFileWriter writer = new XlsxFileWriter();
writer.ProgressPercentChanged += writer_ProgressPercentChanged;
writer.Write("output.xlsx", ds, true);
Console.WriteLine("Writing Over!");
ds = reader.Read("output.xlsx", true);
Console.WriteLine("Rereading Over!");
Console.ReadKey();
}
public void SaveToStream(Stream fs, XlsxFileWriterOptions options)
{
using (var xw = new XlsxFileWriter(fs)
{
Options = options
})
xw.Write(this);
}
private void btnTest2_Click(object sender, RoutedEventArgs e)
{
try
{
string file = @"D:\test.xlsx";
string[][] contents = new string[1][];
contents[0] = new string[3];
contents[0][0] = "fdsfds";
contents[0][1] = "123456";
contents[0][2] = "你好";
XlsxFileWriter.WriteXlsx(file, contents);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SaveToStream(Stream fs, XlsxFileWriterOptions options)
{
using (var xw = new XlsxFileWriter(fs) { Options = options })
xw.Write(this);
}
