openxml spreadsheat save-as

by

To my knowledge there is no built in way to change the filename, but since one way to edit the file is to use streams you can easily give the name of the file you want when writing out the contents of a stream:

byte[] byteArray = File.ReadAllBytes("C:\\temp\\oldName.xltx");
using (MemoryStream stream = new MemoryStream())
{
    stream.Write(byteArray, 0, (int)byteArray.Length);
    using (SpreadsheetDocument spreadsheetDoc = SpreadsheetDocument.Open(stream, true))
    {
       // Do work here
    }
    File.WriteAllBytes("C:\\temp\\newName.xlsx", stream.ToArray()); 
}

There are other ways to change the name as well, like when returning the file to a user in an ASP.NET MVC web application, but it depends on what you are trying to do.

More Related Contents:

  1. Export DataTable to Excel with Open Xml SDK in c#
  2. open xml reading from excel file
  3. Optimal way to Read an Excel file (.xls/.xlsx)
  4. Why appending AutoFilter corrupts my excel file in this example?
  5. How to create Excel file using OpenXML without creating a local file?
  6. Reading Excel files from C#
  7. Write Array to Excel Range
  8. Format an Excel column (or cell) as Text in C#?
  9. export to Excel from a list with EPPLUS
  10. Import and Export Excel – What is the best library? [closed]
  11. How to write some data to excel file(.xlsx)
  12. How to export a JQgrid data to Excel using c#?
  13. How to use Microsoft.Office.Interop.Excel on a machine without installed MS Office?
  14. Is there any simple way to convert .xls file to .csv file? (Excel)
  15. Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’
  16. Microsoft.Office.Interop.Excel really slow
  17. How to reference Microsoft.Office.Interop.Excel dll?
  18. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  19. Reading Excel Files as a Server Process
  20. Is csv with multi tabs/sheet possible?
  21. How to know if a cell has an error in the formula in C#
  22. how to solve Exception:Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)) in C#?
  23. Add HTML String to OpenXML (*.docx) Document
  24. C# – How to add an Excel Worksheet programmatically – Office XP / 2003
  25. How to read more than 256 columns from an excel file (2007 format) using OLEDB
  26. How to import all the Excel sheets to DataSet in C#
  27. Scientific notation when importing from Excel in .Net
  28. Accessing an open Excel Workbook in C#
  29. As of today, what is the right way to work with COM objects? [duplicate]
  30. Import Excel to Datagridview

Leave a Comment