Guest User

Untitled

a guest
Jun 21st, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.81 KB | None | 0 0
  1. using OfficeOpenXml;
  2. using System.IO;
  3.  
  4. namespace ConsoleApplication1
  5. {
  6. class Program
  7. {
  8. static void Main(string[] args)
  9. {
  10. using (var package = new ExcelPackage())
  11. {
  12. var book = package.Workbook;
  13. var dataSheet = package.Workbook.Worksheets.Add("Data");
  14. var pivotSheet = package.Workbook.Worksheets.Add("Pivot");
  15. dataSheet.Cells[1, 1].Value = "<"; //タイトル行が"<"を含むと例外 (ただし">"ならばOK)
  16. dataSheet.Cells[2, 1].Value = "<"; //データ行ならOK
  17. pivotSheet.PivotTables.Add(pivotSheet.Cells[1, 1], dataSheet.Cells[1, 1, 2, 1], "Table"); //ここで例外が発生する
  18. package.SaveAs(new FileInfo("test.xlsx"));
  19. }
  20. }
  21. }
  22. }
Add Comment
Please, Sign In to add comment