C#操作WPS表格转置粘贴

添加引用

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();

将一个csv一行转换成一列，并可以自定义粘贴起始单元格