Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling in spreadsheet content when it contains emojis

Status
Not open for further replies.

Shedders101

IS-IT--Management
May 12, 2015
16
GB
Hi,

Does anyone have experience of grabbing data from an excel spreadhseet and writing it to web pages when that content contains emojis?
It doesn't work well at all for me. The emojis come in as question marks. I believe they are UTF-8 characters. Do you have to add anything to the usual connection code to make it deal with these types of characters properly? The rest of the text comes in fine.

Original (XLS) file
excel1_h9k5p3.jpg


Result in the page
result_xrawwz.jpg


thanks
 
This does it...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
response.Charset = "utf-8"
objConn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DATASOURCE_HERE & ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"";"
%>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top