Hi, Please help me to solve the problems
Step of my job
Read File Excel and get only sheetname start with “Upload”
2.Read range of that sheet to data table → ExcelDT
3.Write New CSV file by ExcelDT
but the problem is open sheetname if it not AutoFit the colums the CSV Result is not correct
How can I AUTOFITS the colums before Read range to Datatables
@Supakinee_Navawong_na_ayu - If you are allowed to use BalaReva activities then install the balareva excel activities and use Autofit columns as shown below
Yoichi
(Yoichi)
January 12, 2021, 5:37am
3
Hi,
The latest excel preview package - UiPath.Excel.Activities v2.10.0-preview - contains AutoFit activity. This might helps you.
UiPath December 2020 Activities Preview Release
While we don’t have a new Studio/StudioX preview version to release this month, we wanted to release some goodies for you just in time for the holidays. Quick side note, we are very excited about the changes we’re making to Studio/StudioX, but they’re not ready yet, so you’ll learn more about those next year.
Today we are pleased to announce that we have some improvements available in our default activity set for StudioX, but of course it is p…
Note: This is for not excel application scope but Use excel .
Regards,
I try to use it in loop for each of sheet name
But it has error on read rage with “error message: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)”
Hi @Yoichi - Is this available in Studio or StudioX? I am using the recent package in Studio and i could not find this activity. I guess, it will be for StudioX
Update:
Yoichi
(Yoichi)
January 12, 2021, 5:45am
6
Hi @prasath17 ,
We can use them in both Studio and StudioX.
Can you try to check ShowStudioX at Filter in Activites panel in Studio as the following?
Regards,
1 Like
@Yoichi - oh wow…I never knew we can use like this…all this time i switch my profile to Studiox and create something and Open the xaml in studio.
Thanks…
1 Like
I coun’t not find UiPath.Excel.Acitivities V2.10.0
What’ s wrong with me?
Yoichi
(Yoichi)
January 12, 2021, 5:58am
9
Hi,
Can you try to check “Include Prerelease”?
Regards,
but I can not find activities “AUTO FIT”
What’ s wrong with me again? T___T
Yoichi
(Yoichi)
January 12, 2021, 6:24am
12
Hi,
Can you tune filter in Activities panel?(Check StudioX)
In the latest version of studio, we can do it as the following image.
If your version of Studio is old, it might be unable to use it.
Regards
Thank you for your help.
My version is old. T__T
system
(system)
Closed
January 15, 2021, 8:32am
14
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.