Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RDB to Excel Sheets Script

umts

IS-IT--Management
Jan 8, 2025
8
Greetings Everyone!

While messing with my Option 11e I wanted to have a way to convert RDB output from terminal to excel sheets so I'd have an easier time figuring things out.

With this rdb-to-excel sheets script I made I can now easily see all my DNs and their associated TNs as well as other infos like Type and Model.
If you have access to such printouts feel free to try it out and tell me if it all worked out here so I can make this work on newer systems too incase it doesn't work.

It should make a different sheet inside the Excel file depending on what type a DN is (Groups things like type 500 and SL1 but separates SL1's with multiple TN's) see Image below.
1739168535721.png I hope someone can find this useful and can forgive my poor coding skills making this.
Feedback greatly appreciated!
- umts
 
Last edited:
I had ago at doing a macro onto the Conversion Utility tool. I could add your worksheet into it?
Feel free to use it! ;)
All I ask is that if it spits out errors or behaves unexpectedly, you message me here or via email so I can work on improving it.
 

Part and Inventory Search

Sponsor

Back
Top