Smrf.NodeXL.ExcelTemplate.ImportFromWorkbookDialog.GetSourceColumnItemText C# (CSharp) Method

    GetSourceColumnItemText
    (
        String sFirstSourceCellValue,
        String sColumnLetter,
        Boolean bSourceColumnsHaveHeaders
    )
    {
        AssertValid();

        if (sFirstSourceCellValue == null)
        {
            // Just use the column letter.

            return ("Column " + sColumnLetter);
        }

        // Truncate the first cell if necessary.

        const Int32 MaxItemTextLength = 30;

        sFirstSourceCellValue = StringUtil.TruncateWithEllipses(
            sFirstSourceCellValue, MaxItemTextLength);

        if (bSourceColumnsHaveHeaders)
        {
            // The first cell is a header.

            return ( String.Format(

                "\"{0}\"",

                sFirstSourceCellValue
                ) );
        }

        // The first cell isn't a header.  Precede the cell value with the
        // column letter.

        return ( String.Format(

            "Column {0}: \"{1}\""
            ,
            sColumnLetter,
            sFirstSourceCellValue
            ) );
    }