export-to-excel

Microsoft Office Excel cannot access the file ‘c:\inetpub\wwwroot\Timesheet\App_Data\Template.xlsx’

by

Try this: Create the directory C:\Windows\SysWOW64\config\systemprofile\Desktop (for the 32-bit version of Excel/Office on a 64-bit Windows computer) or C:\Windows\System32\config\systemprofile\Desktop (for a 32-bit version of Office on a 32-bit Windows computer or a 64-bit version of Office on a 64-bit Windows computer). For the Desktop directory, add Full control permissions for the relevant user (for example … Read more

How to export dataGridView data Instantly to Excel on button click?

by

I solved this by simple copy and paste method. I don’t know it is the best way to do this but,for me it works good and almost instantaneously. Here is my code. private void copyAlltoClipboard() { dataGridView1.SelectAll(); DataObject dataObj = dataGridView1.GetClipboardContent(); if (dataObj != null) Clipboard.SetDataObject(dataObj); } private void button3_Click_1(object sender, EventArgs e) { copyAlltoClipboard(); … Read more

How to Freeze Top Row and Apply Filter in Excel Automation with C#

by

I figured it out! @Jaime’s solution to freezing the top row worked perfectly. And the following is my solution to applying the filter: Thanks, KBP // Fix first row workSheet.Activate(); workSheet.Application.ActiveWindow.SplitRow = 1; workSheet.Application.ActiveWindow.FreezePanes = true; // Now apply autofilter Excel.Range firstRow = (Excel.Range)workSheet.Rows[1]; firstRow.AutoFilter(1, Type.Missing, Excel.XlAutoFilterOperator.xlAnd, Type.Missing, true);

phpexcel to download

by

Instead of saving it to a file, save it to php://output­Docs: $objWriter->save(‘php://output’); This will send it AS-IS to the browser. You want to add some headers­Docs first, like it’s common with file downloads, so the browser knows which type that file is and how it should be named (the filename): // We’ll be outputting an … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)