I would like to rename the SHEET “users-2020-04-27-063645” (which has the date changing every day by a simple title: “users” ) . Thanks to your help
I would like to rename the sheet users-2020-04-27-063645 (which has the date changing every day by a simple title: users)
check this post:
@Al_Bert - You can use StudioX features in Studio, after selecting StudioX in filter option under activities…
Can you please download “BalaReva.Excel.Activites” in manage packages, that would be help to rename the spread sheet.
OK, thanks anyone but the file changes everydays (and all proposals are to a classique sheet name) and I want to have just “users” in sheet name.
The original sheet : “users-2021-04-27-063645”
I want to : “users”
First Get sheet names:
xl_wb = New ClosedXML.Excel.XLWorkbook(File_Name) Sheets = xl_wb.Worksheets //xl_wb As ClosedXML.Excel.XLWorkbook //Sheets As ClosedXML.Excel.IXLworksheets //File_Name As System.String
Then use variable parameters to rename existing sheet using:
Important: This code works ony with .xlsx files
I don’t see how to integrate all this !!
I answered the question myself,
I went through an ASSIGN, a VAR in workbook.GetSheets (0) and a Rename Work Sheet with this VAR
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.