How to convert excel file (.xlsx) to .prn format

Help Studio
,
1

Hi,

I am trying to convert excel file to prn file.

I tried with extension change method, it is not giving expected result.

Please help me here.

Thanks in advance.

2

Did you try with “Rename file” activity?
image

Here you will have to Uncheck “keep extension” and it will give you the extension youn wanted to get.
Edit: in “path” you have to give it your file path.

1 Like
3

Thanks for your reply.

I tried this. prn file created but data is not in readable format.

If I manually try with save as & then select prn as format type, it works fine.

Maybe I need VBA code here.

4

@Jayesh_678
Why can’t you replicate the same in automation.Change Excel file to PRN file

5

I tried VBA code mention on the link. But getting error…

6

Hello @Jayesh_678
Try Copy file actvity
Select the file and copy to same or different location and provide Filename with prn extension

image

7

Not works for me.

Any VBNet code?

8

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