c# - 赋值的左侧必须是我的代码中的变量、属性或索引器
问题描述
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(Type.Missing);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;
if (dgvSearchStudFees.Visible == true)
{
for (i = 0; i <= dgvSearchStudFees.RowCount - 1; i++)
{
for (j = 0; j <= dgvSearchStudFees.ColumnCount - 1; j++)
{
DataGridViewCell cell = dgvSearchStudFees[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}
var savefiledialog = new SaveFileDialog();
savefiledialog.FileName = "Atharva ExcelSheet";
savefiledialog.DefaultExt = ".xlsx";
if (savefiledialog.ShowDialog()=DialogResult.OK) // here I m getting an error "The left-hand side of an assignment must be a variable, property or indexer" Don't know what is wrong. Same as above If statement. its a code for exporting the Data Grid View data to Microsoft excel. I tried doing this code but still I don't understand why this error occurs.
{
xlWorkBook.SaveAs(savefiledialog.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
xlApp.Quit();
}
请帮我处理这段代码。
解决方案
Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
xlApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(Type.Missing);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;
if (dgvSearchStudFees.Visible == true)
{
for (i = 0; i <= dgvSearchStudFees.RowCount - 1; i++)
{
for (j = 0; j <= dgvSearchStudFees.ColumnCount - 1; j++)
{
DataGridViewCell cell = dgvSearchStudFees[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}
var savefiledialog = new SaveFileDialog();
savefiledialog.FileName = "Atharva ExcelSheet";
savefiledialog.DefaultExt = ".xlsx";
if (savefiledialog.ShowDialog() == DialogResult.OK) // This should be == . "=" means assignment to left hand side
{
xlWorkBook.SaveAs(savefiledialog.FileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
}
xlApp.Quit();
}
推荐阅读
- python - 使用列表推导计算所有列表元素的总和
- java - 尝试从 Helidon MP 读取文件时出错
- git - 创建然后合并两个完全不相关的 git 分支
- python - 使用 python pandas 对数据框进行永久更改
- mongodb - `mongoose.model()` 的第二个参数应该是模式或 POJO
- python - Python Selenium 选择具有相似类名的元素
- java - Java 将 Arrays$ArrayList 导出到 csv
- javascript - 如何计算给定大块(例如 5GB)的摘要?
- c++ - 使用模板类c ++的朋友函数
- python - 使用 VPN 使用 MongoClient 保存文档时出现 ServerSelectionTimeoutError,没有身份验证错误