且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

sql查询从excel获取列名。

更新时间:2023-01-29 23:17:08

;
/// /错误246无法将类型'string'隐式转换为'string []'

}
}





它给我的错误如上图所示。请指导我如何解决?







谢谢

Harshal


尝试:

  SELECT  *  FROM  [Sheet1 


A1:A65536]




  SELECT  [F1]  FROM  [Sheet1 

Hello Team,

I am getting the Data from Entity.
I want the column Name From Excel in C#.I wrote the Method as Follows .

private static string[] GetColumnRangeForExcel(IFileLog fileLog)

    {
string[] townNameArray = null;

if (fileLog.FileName) //// Error 245 Cannot implicitly convert type 'string' to 'bool'

{

            townNameArray = "select Town Name from [" + fileLog.FileName + "$]";
            //// Error  246 Cannot implicitly convert type 'string' to 'string[]'

          }
}



its give me error as shown above.Please Guide me how to solve it ??



Thanks
Harshal

"; //// Error 246 Cannot implicitly convert type 'string' to 'string[]' } }



its give me error as shown above.Please Guide me how to solve it ??



Thanks
Harshal


Try:
SELECT * FROM [Sheet1


A1:A65536]


or

SELECT [F1] FROM [Sheet1