Jump to content

Recommended Posts

Hi guys,

I want to use Vi to format convertion, that .mht to .xlsx of Excel, or .html to .xlsx of Excel, Input path of file, output path of .xlsx.

I try to  find active X to realize the target, but I can not find.

I don't know what to do.

Share this post


Link to post
Share on other sites

Post what you've tried so far.  Normally I'd suggest using the report generation toolkit with the template path, being the path to the original file, and then use the Save Report with the new path, but I'm guessing you mean you want to save a table which is in the HTML file, but without an attached file it is hard to say.  Post what you have, post what you've done, and post what you want the output to be.  This will likely involve ActiveX and/or the report generation toolkit, but there just isn't enough information to answer your question.

Share this post


Link to post
Share on other sites
6 hours ago, hooovahh said:

Post what you've tried so far.  Normally I'd suggest using the report generation toolkit with the template path, being the path to the original file, and then use the Save Report with the new path, but I'm guessing you mean you want to save a table which is in the HTML file, but without an attached file it is hard to say.  Post what you have, post what you've done, and post what you want the output to be.  This will likely involve ActiveX and/or the report generation toolkit, but there just isn't enough information to answer your question.

   Hi hooovahh, Thanks your answer.

   I had achieved html to mht(MHTML) so far (below 01 HtmlToMht_0A.vi), then I want converting between mht and xlsx(Excel), or html to xlsx straightly, at last the VI output path of xlsx.

01 HtmlToMht_0A.vi

Share this post


Link to post
Share on other sites

The following file in the report generation toolkit performs the Save As function:

<vi.lib>\Utility\NIReport.llb\Excel\Save Report to File.vi

It has a case constant that uses the following values, I'm unsure if these same values can be used for the document save function.

xls -4143

xlt 17

htm, html 44

xlsx 51

xltx 54

xlsm 52

pdf 57

csv 6

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.