Excel to Markdown

[David Chambers]

Thanks for sharing this, Sherwood. I'd probably have exported a CSV and
written a Python program to do the conversions, but solving the problem
using Excel itself is a much better solution. :)


On 2 February 2014 08:33, Sherwood Botsford <sgbotsford at gmail.com> wrote:


> While MMD is wonderful, much of the time you want to do other things with

> the data first.

>

> My problem:  I have a whole bunch of small tables I keep on an excel

> spreadsheet for setting my prices for various numbers of trees and whatnot.

>

>

> Here's a couple recipes for using excel data.

>

> Layout your spreadsheet as normal.

> Insert a blank row for the formating row.

> Create a wide column to the right of your table

>

> Each row corresponding to a table row has a formula something like this:

>

> "|"&A1&"|"&B1&"|"&C1...

>

> You will need to modify for possible grouping.  E.g. A one line title on a

> 5 column table will end up being

> "|"&A1&"||||"

>

>

> In the blank cell corresponding to the formatting row, type an appropriate

> string of |:--------:|...

>

> My problem was a bit messier than that.  I advertise on Canada kijiji (not

> the same as the US version)  They allow some formatting in ads but do not

> have a table format at all.

>

> I needed as ascii table.  The results of cut and paste from excell into a

> text processor are less than stellar, as data is separated with a single

> tab character.  Anything that lines up is coincidence.

>

> My route was to take this notion one step further, and make an ascii

> formated column that would work for either MMD or for text base ads.

>

> First attempt:

>

> "|" & A1 & REPT(" ",15-LEN(A1)) &

> "|" & B1 &...

>

> I didn't like the hard coding of the column widths.

> And if your source column is $2.50 it comes across as 2.5

>

> Second attempt.

>

> 1 blank column for column I want to use.

>

> If our table is 5 columns wide, I need another 5 columns.

>

> F1 in this one has the formula =TEXT(A1,"$0.00")

> Replicate across and down as needed.

>

> Secondly, insert a row above.  In this row, but the column width you want

> for the output.

>

> Now your formula for K2 will look like this:

> "|" & F1 & REPT(" ",K$1-LEN(F1)) &

> "|" & G1 ...

>

> At this point if I want flush right text, I have to reverse

> the REPT and the Cell reference.  No thoughts of centering.

>

> Sample output results

>

> |Bareroot Bundles of 25 2-3 year olds                      ||||

> |Bundles             |# Trees   |      Cost| Price Per Tree|

> |:-------------------|:---------|---------:|--------------:|

> |5 Trees             |5         |    $30.00|          $6.00|

> |Single Bundle       |25        |    $75.00|          $3.00|

> |5 Bundles           |125       |   $300.00|          $2.40|

> |10 Bundles          |250       |   $525.00|          $2.10|

>

>

>

> Respectfully,

>

> Sherwood of Sherwood's Forests

>

> Sherwood Botsford

> Sherwood's Forests --  http://Sherwoods-Forests.com

> 780-848-2548

> 50042 Range Rd 31

> Warburg, Alberta T0C 2T0

>

> _______________________________________________

> Markdown-Discuss mailing list

> Markdown-Discuss at six.pairlist.net

> http://six.pairlist.net/mailman/listinfo/markdown-discuss

>

>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://six.pairlist.net/pipermail/markdown-discuss/attachments/20140202/8e66a589/attachment.html>