Jump to content
Sign in to follow this  
toddcbrf2

tool to convert data from excel to create evenly spaced

Recommended Posts

toddcbrf2

Ok, here's a request to those alot more experienced than I am. Here's what I'm looking to do and am looking for some feedback

  • overall intent is to convert inputted data to evenly spaced columns of data - or an evenly spaced text table from copied data from excel
  • create a tool where excel data is copied to a section - could be textbox, listview, etc, have observed that tabs are placed in between columns of data
  • user would copy data from excel or html tables, and click a button to paste into the input data section
  • user would select options then hit a button to convert data to aligned columns
  • user then would copy the modified text table to the clipboard so then could be pasted into text based software
  • input would be approx 15 columns wide and 100 rows long
  • has an option to also enter 'space pipe character space' in between rows
  • option also includes the number of spaces between columns, ie, from 2 to 6 spaces between columns
  • this is work related tool for a monospacial font to handle various type of information exported from excel and create evenly spaced rows - could also be used for notepad or notepad++ without formatting
  • we use excel tools with hidden rows that I don't want included - ie, if copy from excel with hidden columns, don't want that info to be placed into the converted text table
  • included is a preliminary GUI and some sample information in the attached excel file
  • temp files can be used to utilize clipboard to copy and paste data
Thank you in advance for your recommendations as I'm not even sure where to start.

post-61772-0-07100900-1367973423_thumb.j

SampleData.xlsx

Edited by toddcbrf2

“Anyone who has never made a mistake has never tried anything new.”― Albert Einstein

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×