Question
How to convert a notepad to excel in openspan?
i need to convert a notepad to excel. should I write a script or is there any other method for it?
example:
custid custName
1 aaa
2 bbb
3 ccc
thanks in advance.!
***Moderator Edit: Vidyaranjan | Updated Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
You can use the Excel connector for this: http://help.openspan.com/80/Components/Microsoft_Excel.htm
Reading out of notepad can be done by interrogating the Notepad window. You will need to read the text line by line and then split it. You can read line by line by using the .Net StringReader. Here is a simple example of reading through the text and splitting by a space.
Add your logic at the end to do something with the data acquired on each line.
Hi Shang,
Yeah I got the solution, By Adding Constructor for type (looks like flower sysmbol,we can find it beside try catch icons) "System.IO.Streamreader" enter then select (String path) in Choose Method overload Pop up, After that i will add to your automation as well as in object explorer, Then You can do any operations with that.
Best Regards,
Anil Nalla
Hi,
Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s available on the top right pane of this page. Once created, please reply back here with the URL of the new post.
You may also refer this discussion link as a reference in the new thread.