C# 操作 WPS 表单转置粘贴
最编程
2024-03-16 22:26:14
...
Excel.Application wpsEt = new Excel.Application();
wpsEt.Visible = true;
Excel.Workbook wb = wpsEt.Workbooks.Open(@"D:\csv.xlsx");
Excel.Workbook wbcsv = wpsEt.Workbooks.Open(@"D:\REadsting.csv");
Excel.Range rowRange = wbcsv.Sheets[1].Range["1:1"];
rowRange.Copy();
wb.Activate();
Excel.Range rowRange2 = wb.Sheets[1].Range["E3"];
//列选择可以用Range["E:E"]
rowRange2.PasteSpecial(Excel.XlPasteType.xlPasteAll, Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, true, true);
Marshal.ReleaseComObject(wpsEt);
Marshal.ReleaseComObject(wb);
Marshal.ReleaseComObject(wbcsv);
//wpsEt.Quit();