Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel 2010 Export as HTML

Posted on 2014-08-20
10
Medium Priority
?
298 Views
Last Modified: 2014-08-27
I'm trying to export my Excel document to an HTML file. Everything is fine and dandy, except the cells that I have hidden are now showing up in the HTML file when I open it up. Any ideas?
0
Comment
Question by:IT_Crowd
  • 5
  • 4
10 Comments
 
LVL 10

Expert Comment

by:etech0
ID: 40273790
I think that would make sense. HTML doesn't know about hiding rows. Maybe you want to delete the hidden cells before exporting?
0
 
LVL 13

Author Comment

by:IT_Crowd
ID: 40273795
:(  unfortunately, I am using some of the columns/cells in formulas and deleting them would break the formulas.
0
 
LVL 10

Expert Comment

by:etech0
ID: 40273804
In that case you might want to select the whole sheet, copy, and paste values.
Unless you want the formulas (as opposed to the results) to come through in your HTML.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 13

Author Comment

by:IT_Crowd
ID: 40273820
I agree with you, and thats what I tried, but it doesnt look like the hyperlink formula will paste correctly - the link is broken.

I'll upload the excel file in question here so it might make more sense.  
AdminRecord.xlsx
0
 
LVL 10

Expert Comment

by:etech0
ID: 40273824
No problem
0
 
LVL 10

Assisted Solution

by:etech0
etech0 earned 2000 total points
ID: 40274052
Okay. Instead of the formula you currently have in column B, put this:
<a href="1984-11-08;DOC;;;DOE Old Wade House.pdf">0000000001</a>

Another thing is that you will have to include somewhere, either in the forumla or in column A, the full file path to where these files are stored, or the html file will not know where to look to find them, and the links won't work.
0
 
LVL 13

Accepted Solution

by:
IT_Crowd earned 0 total points
ID: 40274072
Thanks for the ideas.

We're currently working on the following possibility: moving the "hidden" columns to sheet 2, creating the HTML file, and then telling the HTML file to hide sheet 2.

Will report back.
0
 
LVL 10

Expert Comment

by:etech0
ID: 40274077
Smart!
0
 
LVL 72

Expert Comment

by:Qlemo
ID: 40274092
Instead I would copy all visible columns to a new or empty sheet,
Or just add references to the visible cells in another sheet, and show that sheet in HTML.
0
 
LVL 13

Author Closing Comment

by:IT_Crowd
ID: 40287420
We ended up using the "move hidden columns to sheet 2" ideas, but etech0's post is also relevant and could have been used to resolve the issue we were having.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an article on how to answer questions, earn points and become an expert.
In this post, we will learn to set up the Group Naming policy and will see how it is going to impact the Display Name and the Email addresses of the Group.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question