ASP: How to import data from a merged cell in Excel?

I need to import data from an excel file, but some field is a merged cell. How can I determine if a field is merged or not, and how many cells are merged together in that field? My code is like this: Dim Conn, DBPath ,Rs Set Conn = Server.CreateObject("ADODB.Connection") DBPath = "Driver={Microsoft Excel Driver (*.xls)}; DBQ=" & Server.MapPath("program.xls") Conn.Open Driver & DBPath Sql="Select F1, F2 From [Sheet1$]" Set ODBCrs=Conn.Execute(Sql) while Not ODBCrs.EOF conn2.execute("insert into....") ODBCrs.MoveNext wend ODBCrs.Close Conn.Close The data is like this: Category A name 1    desc 1 name 2    desc 2 Category B name 3    desc 3 name 4    desc 4 Thanks a lot!!
I don't understand your meaning.

以上就是ASP: How to import data from a merged cell in Excel?的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准