Member Avatar for cptsafety
cptsafety 0 Newbie Poster

Two questions: I have an Excel file with multiple sheets that I want to display on a normal web form. I have found how to get the connectionString right.

Question 1: Does the entire file path need to be in the connection string? I'd like to upload and update the file in a web directory regularly, so it would be easier to have a relative link in the connection string.

Question 2: I've gotten my page to see only the columns I want displayed, but only one sheet. Is there a way to display multiple sheets through a paging or tab setup?

Any help would be welcome.

  • 1 Contributor
  • 0 Replies
  • 58 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.