ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Create Excel sheet in HTML with comments (https://www.excelbanter.com/excel-programming/279039-create-excel-sheet-html-comments.html)

Luke Webber

Create Excel sheet in HTML with comments
 
"David McRitchie" wrote in message
...
Hi Luke,
one way, there will be no formatting of any kind, and no indication that
a title (comment) is included.

<table<tr<td title="This is a Comment"This is data</td</tr</table


Thanks, but it's not really what I'm looking for. I want the user to see the
comment as a normal Excel comment. In fact, I'd already tried the TITLE
attribute, with no effect.

Any more thoughts? It seems like it should be simple, but the Connectivity
Kit is pretty half-arsed from what I've seen.

I'd use XML, but it looks like the bulk of the client PCs will be running
Office 97. 8^(

Cheers,
Luke


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luke Webber" wrote in message

om...
Hi.

I'm using the information in the Web Connectivity Kit to generate
simple HTML via ASP for import by Excel. So far, smooth sailing. But I
just hit my first speed hump.

I want to include a comment field on certain cells of the spreadsheet,
and I can't find any mechanism for doing so. I've tried unravelling
exported HTML straight from Excel, but that stuff is incredibly
complex, so I'm hoping there might be a simpler alternative.

Any ideas?

Thanks for any and all suggestions.

Luke






Luke Webber

Create Excel sheet in HTML with comments
 
Hi.

I'm using the information in the Web Connectivity Kit to generate
simple HTML via ASP for import by Excel. So far, smooth sailing. But I
just hit my first speed hump.

I want to include a comment field on certain cells of the spreadsheet,
and I can't find any mechanism for doing so. I've tried unravelling
exported HTML straight from Excel, but that stuff is incredibly
complex, so I'm hoping there might be a simpler alternative.

Any ideas?

Thanks for any and all suggestions.

Luke

David McRitchie[_2_]

Create Excel sheet in HTML with comments
 
Hi Luke,
one way, there will be no formatting of any kind, and no indication that
a title (comment) is included.

<table<tr<td title="This is a Comment"This is data</td</tr</table


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Luke Webber" wrote in message om...
Hi.

I'm using the information in the Web Connectivity Kit to generate
simple HTML via ASP for import by Excel. So far, smooth sailing. But I
just hit my first speed hump.

I want to include a comment field on certain cells of the spreadsheet,
and I can't find any mechanism for doing so. I've tried unravelling
exported HTML straight from Excel, but that stuff is incredibly
complex, so I'm hoping there might be a simpler alternative.

Any ideas?

Thanks for any and all suggestions.

Luke





All times are GMT +1. The time now is 05:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com