Need a plug-in, or external program that imports a delimited file. This might also be a Visual Basic macro for Excel. Take your pick! I'd prefer a standalone executable (with source code provided as part of the deliverable) but I'm also attracted to simple solutions that don't cost a lot.
This plug-in or program will take a simple Excel table with "x" rows and "y" columns and convert it into readable text. A simple table is defined as a table with only one row of column headers and only one column of row headers and no subheadings.
If this was a plug-in for Excel the user would define the table using a named range or select the table, or enter the number of rows and columns -- whatever works best. The plug-in would then parse the data and produce text output that can be either copied to the clipboard and used in another application or saved to a text file.
If the table looks like this (where Hdr A is the column heading for column 2, RHdr 1 is the row heading for row 1, etc.):
Hdr A Hdr B Hdr C
RHdr 1 data data data
RHdr 2 data data data
RHdr 3 data data data
The output would look like this:
RHdr 1, CHdr A: data; CHdr B: data; CHdr C: data
RHdr 2, CHdr A: data ; CHdr B: data; CHdr C: data
RHdr 3, CHdr A: data ; CHdr B: data; CHdr C: data
That would be good for starters. An step up would allow the user to choose the format of the output -- maybe they want to repeat the Row headers (RHdr) as:
RHdr 1, CHdr A: data;
RHdr 1,CHdr B: data;
RHdr 1,CHdr C: data
RHdr 2, CHdr A: data ;
RHdr 2, CHdr B: data;
RHdr 2, CHdr C: data
RHdr 3, CHdr A: data ;
RHdr 3, CHdr B: data;
RHdr 3, CHdr C: data
A more sophisticated version would deal with complex tables (tables with more than one row of column headers or more than one column of row headers.)
Please state what programming language and version you would use, the timeframe for completion, and the cost for additional work such as minor revisions by the hour.
Thanks!
Hi Raeben, We will go with Excel macros and we will create .txt files for the ouput. BTW, which OS are you using - MAC or WINDOWS - We develop apps only for all WINDOWS machines. thanks !
Hi This is Piyush Patel
I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess.
I have developed many applications in VB6,VBA,VB.NET.
Please Check My PM
I will make a standalone application using AINSI C that can be compiled with any C compiler. I am writing well documented code that can easyly be modified afterward. Interface with the user will be inside a Command Prompt window. For extra work I ask $10 per hour. Complex tables implementation would take 2 hours so $20.
Hi,
I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services.
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project.
Thanks,
Murtaza
I can get this done in a day's time and could make you a simple app that would output it to a window you can then simply copy and paste from. Or if you have another preference we can make that work. I have a lot of experience programming and in Excel and have sent you a PM with a sample of my work!
HI,
I have over 8yrs of experience working with excel macros.
I understand your requirements and would like to take up this project. The solution will be created as an excel macro as no complicated programming is involved and also because the code will be easy for you to maintain in the future.
If you want I can create a standalone solution in vb.net, but I am in favour of excel because of its flexibility that we will need for future versions.
The delivery time I have quoted includes testing and minor enhancements.
Please provide me a sample file so we can start working. I look forward to working with you.
thanks & regards
I will use Excel 2010 + VBA to code this. From the Ribbon Button click user will get the Form to select the parameters, like Sheet/Range/Rangename to convert, type of conversion (From your sample) and output folder.
Output will be generated in .txt file asking the name of the file. It will take about 2 days to complete the job with testing from your side. For further extended work, I will charge $25/- per hour. or we can discuss the type of complexity of the work and mutually agree a lump sum amount. As you wish. I am ready to start now.