Comments by pjhelp (Top 16 by date)

Thanks for your reply.
But is this able to copy data from HTML to an EXLX formated file.And also is this indipendent of Office 2007 in the machine.I mean, can it be able to create Excel file with out MS Excel.

Thanks for your guidance .Now i'm not getting any error ,but getting an Worning as -

warning C4996: 'strcpy': This function or variable may be unsafe. Consider using strcpy_s instead. To disable deprecation, use _CRT_SECURE_NO_WARNINGS. See online help for details.

Can you please guide me how can i avoid this Worning
Thank you .

Thanks a lot for your quick response.
Here i'm not trying to change the exact string.If you see carefully you can find
i'm changing to "HTML Files (*.xlsx)|*.xlsx|All Files (*.*)|*.*||" from "HTML Files (*.xls)|*.xls|All Files (*.*)|*.*||" accoring to the requirement.

Thanks

Thanks a lot for your quick response.
But while i'm assigning different string values ,its giving 'String length' error. Let me be perticular about the String as below -

static char BASED_CODE szFilter[] = "HTML Files (*.xls)|*.xls|All Files (*.*)|*.*||";

if (AppMarketID == 12)
{
szFilter = "HTML Files (*.xls)|*.xls|All Files (*.*)|*.*||";
}

CFileDialog dia(FALSE, "", default_name, OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT, szFilter);


I’m getting error as -
error C2440: '=' : cannot convert from 'const char [49]' to 'char [47]'

Thanks a lot for your quick response.
Can you please tell me how to get the DLL from that site.Because i didn't find any link to download that DLL. Can you please guide me
Thanks

Hi Mr.Pand,
Thanks for your reply.
Before you i'hd tried with this link. But i faced problem how to impliment in my application.I'hd gone through it's site,but i didn't find any proper step for implimentain.
Can please gide how to use that 'ExcelWriter' in my existing C# project. I mean to say hoe to get that Library & steps to add this Library in .Net Environment. Please guide me if you have implimented it in past.

Thank U :)

Valery,
Can we generate XLS file even though Microsoft EXCLE is not exist in client machine programatically. Whether the above code stuff can generate for us ?

Right now i don't have a machine which is not having MS EXCEL ,to test this.If you have any concrete idea then kindly please let me know soon. Thaks again.

Thank you Valery.
Your guide lines helped me a lot to resolve my issue.

Yes Dave, I came to know "an .xlsx file is opened strictly as a Zip package used by 2007 office applications." . I also followed your suggestion and observed the same.
Still i'm hoping there may be any indirect way to create an XLSX file from a HTML file.Kindly please update me if you have any new idea.
And thanks for your response.

Here how i'm using this method -
File.Copy(@"C:\\Program Files\\Proj\\Configurations\\XYZ.html", @"C:\\Program Files\\Proj\\Configurations\\ABC.xlsx", true);

ProcessStartInfo startInfo = new ProcessStartInfo("Excel.exe");

startInfo.Arguments = '"' + "C:\\Program Files\\Proj\\Configurations\\ABC.xlsx" + '"';
Process.Start(startInfo); // It opens this 'ABC.xlsx' file

Its a MFC application but using c# code.And its running in Microsoft Visual Studio 2008