Export Excel to Utf8 css

Posted on 2011-10-13
Last Modified: 2012-05-12

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
Question by:starhu
    LVL 15

    Accepted Solution

    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

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

    Author Closing Comment

    It gave me only some clues, I had to figure out most of it myself

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now