Avatar

Rubal Grewal

  • Total activity 15
  • Last activity
  • Member since
  • Following 0 users
  • Followed by 0 users
  • Votes 0
  • Subscriptions 5

Activity overview

Latest activity by Rubal Grewal
  • Avatar

    Rubal Grewal commented,

    Thank you Gerry for the quick code but the pivot is still getting distorted as the date is "15/02/2021" in this format and cant be changed to "2021-02-15". The moment I refresh on pivot after creat...

  • Avatar

    Rubal Grewal commented,

    Thank you so much Gerard for the quick response but I have tried leaving "Output spec" blank so that data gets appended at the end but still the data gets added at the top instead of bottom in the ...

  • Avatar

    Rubal Grewal created a post,

    Excel template data appended in opposite direction

    I am using a template (excel file) that has some data and pivot already created by another team. I need to write new data to that excel file at the end so that existing data is not touched and pivo...

  • Avatar

    Rubal Grewal commented,

    Thank you so much Adrian for the quick support. Really appreciate it. But can you please let me know if it is possible to append the data in excel and update pivot instead of recreating it. As when...

  • Avatar

    Rubal Grewal created a post,

    Pivot table and date column issue

    I am reading the report for customers where the date and amount transferred is mentioned and create a pivot table. But if I am passing the date attributes then it gets reflected as “28-01-2021” and...

  • Avatar

    Rubal Grewal created a post,

    double quotes issue in output text file

    I am creating an output file "XYZ.txt" based on some logic but double quotes are getting added in the final data. There are 3 inputs to a cat file (all string) but for the middle input double quote...

  • Avatar

    Rubal Grewal commented,

    It worked fine Gerry but for the output excel, it is just writing new data. The old worksheets present in the file are not getting reflected in the new file. Also, for the tab name in the new sheet...

  • Avatar

    Rubal Grewal commented,

    You are awesome Gerry!!! Thank you so much for the quick support and the sample shared. I will test it and share the update... Really Appreciate your efforts

  • Avatar

    Rubal Grewal created a post,

    Dynamic Sheet in Excel

    I am reading a file which contains month-wise data and updates the file based on some logic. If the excel contains the "current month" tab then I need to append new data to the existing data sheet ...

  • Avatar

    Rubal Grewal created a post,

    Text file creation issue

    I am trying to create a text file based on some data input from different sources but not able to understand how to create file with extension txt. The contents contain pipe and comma separated dat...