?
Solved

Export Excel to Utf8 css

Posted on 2011-10-13
2
Medium Priority
?
335 Views
Last Modified: 2012-05-12
Hello,

My customer needs to convert his Excel files regulary into css (for his webshop).

He uses export as css. The problem is that the Hungarian characters are lost.

I found some methods on the net to edit the css with notepad++ and so on, but my customer even curses for having to do a "save as" -> in his opinion this is the most complicated thing to do.

So have you got an easy process to convert the Excel file to an UTF8 css? (with comma separated)

Thank you
0
Comment
Question by:starhu
2 Comments
 
LVL 15

Accepted Solution

by:
Simon Ball earned 1500 total points
ID: 36967461
in access i have used open file output to export data sets..

you could do that in excel in a macro too...rather than using excel export, it might save the characters.

dim strList as String
  'loop through calculations here
  '   assign the values, e.g., "A", "B", etc. to strList
  '  example:  strList = strList & strNewValue
  Open "c:\List.txt" For Output As #1
  Write #1, strList
  Close #1

http://www.tek-tips.com/faqs.cfm?fid=3767

you could loop through the cells in range and output the contents to file, line by line.
0
 

Author Closing Comment

by:starhu
ID: 36986205
It gave me only some clues, I had to figure out most of it myself
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

864 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