Excel to Confluence Converter

I opened your spreadsheet, then opened the one I wanted to convert. I see the 'Copy to Confluence' button on the menu and when I highlight the cells I want to convert and then click the button, I get an error message: 'ExcelToConfluence.xls' could not be found. Check the spelling of the name...' etc. Is this a bug in your macro, or is it operator error ? Thanks...P.Damron

This worked great. Thanks for writing this script.
To the previous comment – I got the same error when I opened the xls directly from the zip file. After I saved it to a folder and opened it from there, it worked perfectly.

Here's an update that handles newlines and other special chars in cells:

Sub SelectionToWiki()
    Dim specialChars As String
    specialChars = Chr(7) & Chr(10) & Chr(13) & "\"
    
    result = ""
    For i = 1 To Selection.Rows.Count
        result = result & "| "
        For j = 1 To Selection.Columns.Count
            Dim cell As Range
            Set cell = Selection.Cells(i, j)
            cellStr = cell.Value
            
            Do While InStr(specialChars, Right(cellStr, 1)) > 0
                cellStr = Left(cellStr, Len(cellStr) - 1)
            Loop
            cellStr = Replace(cellStr, Chr(13), "\\" + Chr(13))
            cellStr = Replace(cellStr, Chr(10), "\\" + Chr(13))
            
            If cell.Font.Bold Then cellStr = "*" & cellStr & "*"
            If cell.Font.Italic Then cellStr = "_" & cellStr & "_"
            result = result & cellStr & " | "
        Next
        result = result & Chr(13)
    Next
    Dim MyDataObj As New DataObject
    MyDataObj.SetText result
    MyDataObj.PutInClipboard
    
    MsgBox "Confluence table copied to clipboard: " & Chr(13) & Chr(13) & result
End Sub
    

In Excel 2002 Italian version don't work:
Macro was fine imported in worksheet and seem working ... last MsgBox correctly appears. But NO chars in clipboard copied.
I suppose that MyDataObj.PutInClipboard dont work. I tried to put
Set cell = Cells(1000, 1)
cell.Value = result
and runs !! but size-char-limit in single cell is a limitation.

Any suggestions ?
Regards
Fabrizio

I had problems with Excel 2002 also, however this script (based on update above) appears to be good. Note: This copies numeric format instead of absolute value (eg: 75% vs 0.75XXXX).

Here's the script:

Sub SelectionToWiki()
    Dim specialChars As String
    specialChars = Chr(7) & Chr(10) & Chr(13) & "\"

    result = ""
    For i = 1 To Selection.Rows.Count
        result = result & "| "
        For j = 1 To Selection.Columns.Count
            Dim cell As Range
            Set cell = Selection.Cells(i, j)
            cellStr = cell.Text
            If Not IsEmpty(cellStr) And cellStr <> "" Then
                Do While InStr(specialChars, Right(cellStr, 1)) > 0
                    cellStr = Left(cellStr, Len(cellStr) - 1)
                Loop
            End If
            cellStr = Replace(cellStr, Chr(13), "\\" + Chr(13))
            cellStr = Replace(cellStr, Chr(10), "\\" + Chr(13))

            If cell.Font.Bold Then cellStr = "*" & cellStr & "*"
            If cell.Font.Italic Then cellStr = "_" & cellStr & "_"
            result = result & cellStr & " | "
        Next
        result = result & Chr(13)
    Next
    Dim MyDataObj As New DataObject
    MyDataObj.SetText result
    MyDataObj.PutInClipboard

    MsgBox "Confluence table copied to clipboard: " & Chr(13) & Chr(13) & result
End Sub

I am having trouble getting the macro to work. ( I'm using excel 2003 )  If I select a part of the spreadsheet to copy over, then press the 'Copy to Confluence' button, I get the correct message box telling me that it has been copied to the clipboard.  However, there doesn't appear to be anything actually copied to the clipboard, or at least I'm not able to paste into anything.  I checked, and my security settings are medium, I even tried bringing them down to low, but it still doesn't seem to work.

I think I found the cause for the issues some people have been seeing; a hardcoded path crept into the macro. 

I have attached an updated verson of the macro that should fix this.  It also includes the formatting improvement noted in Brian Fisher's message.

Note:  Since I don't know how to check into subversion yet, I uploaded the changes as an attachment to this page.  As soon as I find the right way to do things, I'll upload to subversion.

Hi,

I just tried to use the brilliant new macro but so far I did not succeed. Open macro, open my own Excel sheet, select cells I want to convert, click button - Excel also shows the correct data saved to the clipboard- everything seems perfectly okay. But when I try to paste the clipboard contents into my Confluence page - nothing happens. Hm. I seem to make a mistake somewhere. Any ideas?

 Thanks,

Kerstin 

Our test installation of Confluence 2 was uninstalled again due to a problem displaying special characters, so I cannot make further tries currently (I'm pretty sure I used the Markup mode, though)- but I can say this much: if I use the ExcelToConfluence.xls in my Excel application and copy cells, I get a pop up window showing precisely what is copied to the clipboard. When I open the clipboard itself at that moment, it also shows the correct data. And I can also paste the clipboard contents into a text editor.

Is there any way to get the macro to include hyperlinks?  Can it be modified for this?

The macro works fine now, thanks!

Hi,

 I have a question with regard wiki tables. Is it possible to change the background colour of individual wiki table cells? If yes, how can this be done?

Appologies if this is the wrong place to ask such a question - I cannot seem to find anywhere more appropriate.

Cheers,

Darren

Is there a way to convert the excel data into a "chart macro" output type?

FYI - I've added a Content Converter for Office. The Excel part is based on this macro, so the functionality is the same with additional functionality:

• Handles both Word (nested tables and inline shapes (e.g. textbox) not working properly) and Excel (no image support in excel yet)
• Inserts the page directly into your Wiki
• Automatically attaches images from Word documents to the page
• Can convert entire trees of documents
• Upload all sheets within the current document
• Either uploads the selection or the entire sheet (if only one cell selected on the sheet).

The plugin is still in early development - e.g doesn't replace existing documents yet - only adds new ones

I am using Excel 2007 - when I click the cells I want to copy, I get an error message "Copy of ExceltoConfluence.xls" cant be found