Skip to main content
Question

Excel Advanced save as command

  • February 7, 2024
  • 9 replies
  • 195 views

Kanwal Shah
Forum|alt.badge.img+3

I have my CNIC stored in an excel sheet and i want to retrieve web data based on those CNIC numbers from a website called NECTA and i want to store the out in another Excel file how can i do that because i dont wanna use Excel Advanced save as a copy command so what else can i use to achieve the desired resuly

9 replies

Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • February 8, 2024

I have my CNIC stored in an excel sheet and i want to retrieve web data based on those CNIC numbers from a website called NECTA and i want to store the out in another Excel file how can i do that because i dont wanna use Excel Advanced save as a copy command so what else can i use to achieve the desired resuly

Hi @Kanwal Shah , You can capture the table→ store it in a DataTable→ write to file (using DataTable variable).


Kanwal Shah
Forum|alt.badge.img+3
  • Author
  • Navigator | Tier 3
  • February 9, 2024

i used Excel advanced set cell command to store corresponding data in each cell like B column for ID, C column for names, D column for Province and so on and when i run the bot it is saving the output in the same file that i used as an input file but i want to save the output in a separate or new excel file i used the log to file command but it is not working can i used the excel advanced save as command wont it just create a copy of my input file but i dont want that i want a separate excel output file that will store my output data in it. which command should i use if i used excel set cell command before 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • February 9, 2024

i used Excel advanced set cell command to store corresponding data in each cell like B column for ID, C column for names, D column for Province and so on and when i run the bot it is saving the output in the same file that i used as an input file but i want to save the output in a separate or new excel file i used the log to file command but it is not working can i used the excel advanced save as command wont it just create a copy of my input file but i dont want that i want a separate excel output file that will store my output data in it. which command should i use if i used excel set cell command before 

@Kanwal Shah, as you want to store in a separate file : You can use Excel Create workbook and store in that, it will be used to create a new file. Also you will have to create headers too for this as it is a new file.

 

Kanwal Shah
Forum|alt.badge.img+3
  • Author
  • Navigator | Tier 3
  • February 9, 2024

@Zaid Chougle thankyou so much let me try this command

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • February 9, 2024

@Zaid Chougle thankyou so much let me try this command

 

Do let me know whether the solution worked or not


Kanwal Shah
Forum|alt.badge.img+3
  • Author
  • Navigator | Tier 3
  • February 9, 2024

@Zaid Chougle  sure i will InshaAllah


Kanwal Shah
Forum|alt.badge.img+3
  • Author
  • Navigator | Tier 3
  • February 9, 2024

@Zaid Chougle its not working out can i use excel Advanced save as a copy command?


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+17
  • Navigator | Tier 3
  • February 9, 2024

@Zaid Chougle its not working out can i use excel Advanced save as a copy command?

Try it.


Kanwal Shah
Forum|alt.badge.img+3
  • Author
  • Navigator | Tier 3
  • February 12, 2024

the create workbook command is not working