Pivot and write excel

Help Activities
, ,
1

I want pivot data and write data to templete excel.
input3.xlsx (14.1 KB)

image
image960Ă—419 34.1 KB

Output I want to write in sheet(sheetName as Filename_Type)
by sum value (Column Cas,Ins,Che,Car) follow data as below. output3.xlsx (18.3 KB)

image
image760Ă—527 20.1 KB

Guide me about it please.

2

It can be done by using VBA macro

Are you familiar with VBA ?

3

@sulungcayadi DON’T​ know​ about​ VBA.
Guide​ me​ please.

4

PlotDataExcelPivot.zip (76.6 KB)

I created this,

Input files:

  1. input3.xlsx (your raw data should come with “input” sheet
  2. output template.xlsx (your output template).

Result file as in Robot variable: resultfilename.

Hope it helps.

1 Like
5

@fairymemay - You can use StudioX feature with in studio, which has the pivot table feature. Have you tried it?

6

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