Question

vba代码问题

xlsws.cells(y,4).Interior.color=255，前面的xlsws是工作表对像，操作完之后，为什么单元格颜色没有变化？

Answer 1

/// <summary>
/// 导出速度最快
/// </summary>
/// <param name="list"><列名，数据></param>
/// <param name="filepath"></param>
/// <returns></returns>
public bool NewExport(List<DictionaryEntry> list, string filepath)
{
bool bSuccess = true;
Microsoft.Office.Interop.Excel.Application appexcel = new Microsoft.Office.Interop.Excel.Application();
System.Reflection.Missing miss = System.Reflection.Missing.Value;
appexcel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook workbookdata = null;
Microsoft.Office.Interop.Excel.Worksheet worksheetdata = null;
Microsoft.Office.Interop.Excel.Range rangedata;

workbookdata = appexcel.Workbooks.Add();

//设置对象不可见
appexcel.Visible = false;
appexcel.DisplayAlerts = false;
try
{

Answer 2

可切换我额呵呵苛刻呵呵的确不如我也不额个好额家务的和基地如何维护服务和基地附近被窝爹呵呵额姐姐额河北我电话我被窝了额