I would like to rename the sheet users-2020-04-27-063645 (which has the date changing every day by a simple title: users)

Help Activities
, ,
1

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

2

Hi,
check this post:

1 Like
3

@Al_Bert - You can use StudioX features in Studio, after selecting StudioX in filter option under activities…

image
image466×808 15.5 KB

image

4

Hi @Al_Bert

Can you please download “BalaReva.Excel.Activites” in manage packages, that would be help to rename the spread sheet.

image
image1124×633 65.2 KB

image
image391×603 17.1 KB

Happy Learning :slightly_smiling_face:

5

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”

6

HI,
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:

Sheets(0).Name.ToString

Important: This code works ony with .xlsx files

7

I don’t see how to integrate all this !! :pensive:

8

Hi all,

I answered the question myself,

I went through an ASSIGN, a VAR in workbook.GetSheets (0) and a Rename Work Sheet with this VAR

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.