VBA转换成c#

[qq_31812171]

在Excel上建了一个宏，功能是合并+填充颜色，转换成c#怎么写？

Sub 宏1()

    Range("A1:E1").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = False
    End With
    Selection.Merge
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = -0.249977111117893
        .PatternTintAndShade = 0
    End With
End Sub

[bloodish]

大致如下,未经测试.

           var excelApp = new Excel.Application();            
            excelApp.Range["A1:E1"].Select();
            excelApp.Selection.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
            excelApp.Selection.VerticalAlignment = Excel.XlVAlign.xlVAlignBottom;
            excelApp.Selection.WrapText = false;
            excelApp.Selection.Orientation = 0;
            excelApp.Selection.AddIndent = 0;
            excelApp.Selection.IndentLevel = 0;
            excelApp.Selection.ShrinkToFit = false;
            excelApp.Selection.ReadingOrder = Excel.Constants.xlContext;
            excelApp.Selection.MergeCells = false;
            excelApp.Selection.Merge(Missing.Value);
            excelApp.Selection.Interior.Pattern = Excel.Constants.xlSolid;
            excelApp.Selection.Interior.PatternColorIndex = Excel.Constants.xlAutomatic;
            excelApp.Selection.Interior.ThemColor = Excel.XlThemeColor.xlThemeColorDark1;
            excelApp.Selection.Interior.TintAndShade = -0.249977111117893;
            excelApp.Selection.Interior.PatternTintAndShade = 0;

[qq_31812171]

引用 1 楼 bloodish 的回复:

大致如下,未…….

这个错误不会弄……

[bloodish]

引用 2 楼 qq_31812171 的回复:

[quote=引用 1 楼 bloodish 的回复:] 大致如下,未…….

这个错误不会弄…… [/quote] 打开一个excel文档再做后面的操作,示例的代码只是保证编译过了.