Winform快速匯出

標籤：winform   datagridview   class   c   ext   a   

public static void ExportExcel(DataGridView DataGridView01)
{
Stream stream = null;
StreamWriter writer = null;
SaveFileDialog dialog = new SaveFileDialog {
Filter = "Execl files (*.xls)|*.xls",
FilterIndex = 0,
RestoreDirectory = true,
CreatePrompt = true,
Title = "Export Excel File To"
};
if (DialogResult.OK == dialog.ShowDialog())
{
try
{
stream = dialog.OpenFile();
writer = new StreamWriter(stream, Encoding.GetEncoding(0));
string str = "";
for (int i = 0; i < DataGridView01.ColumnCount; i++)
{
if (i > 0)
{
str = str + "\t";
}
str = str + DataGridView01.Columns[i].HeaderText;
}
writer.WriteLine(str);
int columnCount = DataGridView01.ColumnCount;
for (int j = 0; j < DataGridView01.Rows.Count; j++)
{
string str2 = "";
for (int k = 0; k < columnCount; k++)
{
if (k > 0)
{
str2 = str2 + "\t";
}
if (k > 0x16)
{
}
if (DataGridView01.Rows[j].Cells[k].Value == null)
{
str2 = str2 ?? "";
}
else
{
str2 = str2 + DataGridView01.Rows[j].Cells[k].Value.ToString();
}
}
writer.WriteLine(str2);
}
writer.Close();
stream.Close();
}
catch (Exception exception)
{
MessageBox.Show("匯出檔案時出錯,檔案可能正被開啟！\n" + exception.Message);
}
finally
{
writer.Close();
stream.Close();
}
MessageBox.Show("儲存成功", "提示", MessageBoxButtons.OK);
}
}

 

 //

如果 ?? 運算子的左運算元非 null，該運算子將返回左運算元，否則返回右運算元。