Excel macro to C# StringToDouble

Question

Excel macro to C# StringToDouble

Jozsi 21

Hi,

This is a visual basik macro: "Columns("E:E").Select
Selection.TextToColumns Destination:=Range("E1"), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(1, 1), TrailingMinusNumbers:=True"

I want C# to do this. What's wrong is that?: "range = osheet1.get_Range("E2", Missing.Value);
range.TextToColumns(Destination:=range,DataType:=xlDelimited,Excel.XlTextQualifier.xlTextQualifierDoubleQuote);"
Best regards,
Józsi

Viorel 127K Reputation points

2020-12-31T11:33:41.013+00:00

The macro seems to select the entire E column, but C# code only gets a single cell: “E2”. Did you try specifying “E:E” instead? For the destination, try Destination:=osheet1.get_Range("E1", Missing.Value).
Jozsi 21 Reputation points

2021-01-01T07:50:51.41+00:00

This code does not give an error, but there is no change in excel.
" range = osheet1.get_Range("E1", Missing.Value);
range = range.get_Range("E:E");
range.TextToColumns(osheet1.get_Range("E1",Missing.Value) , Excel.XlTextParsingType.xlDelimited,
Excel.XlTextQualifier.xlTextQualifierDoubleQuote, false, false, false,
false, false, false, false, Excel.XlColumnDataType.xlGeneralFormat,
Missing.Value, Missing.Value, true); "
Timon Yang-MSFT 9,611 Reputation points

2021-01-04T08:26:31.48+00:00

@Jozsi
I am not familiar with Visual Basic macros. Could you please add some text descriptions or pictures to illustrate your current needs?
Looking forward to your reply.