629 Topics
 | |
| | Hi, I'm trying to generate Docx files using python. I searched the web and found a module: https://github.com/mikemaccana/python-docx/blob/master/README.markdown It says to install using easy_install or pip, which I have no idea how to do. I also have a mac so I think that makes it a little more complicated. I'm …  |
| | I have problem with writing csv file using **fputcsv**. Its putting the page html also into the csv file. Whats wrong with my code ? //Excel header header("Content-Disposition: attachment; filename=\"Delivery_Reports.csv\";" ); header("Content-type: application/vnd.ms-excel"); $out = fopen("php://output", 'w'); $flag = false; // $result = mysql_query("SELECT * FROM senderids ") or die('Query … |
| | Hi, I'm trying to export data from excel sheet to my grid, I'm using the foll code, but I get an error at DataGridView1.Rows.Add(), saying rows cannot be added programmatically. Private Sub btnexport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnexport.Click Dim xlsApp As Microsoft.Office.Interop.Excel.Application Dim xlsbook As Microsoft.Office.Interop.Excel.Workbook …  |
| | Hi all, Not sure if this is something that is possible or not but what i'm looking for is as follows....... I have an excel sheet of football league tables. The sheet automatically updates when I enter in results I'm looking for a way (prefibally in HTML as i'm fairly …  |
| | Hi, I've written a routine for a customer to import sales orders into their Sage system. Everything was going well but the client has come back with a particular excel sheet that is not importing. He is getting a message to tell him the sheet is not in a valid … |
| | Hi Guys!! I am creating an addin in Excel using VB.Net. I want to access the current worksheet using a ribbon designer. I have tried all sorts but to no avail. Also all the resources that I have checked are providing solutions by adding or opening new workbook. What I … |
| | Hi to everyone. I have created jsp report in that date column is there where am showing the date format like this (02-01-2012) <% String Rcheckdate=""; SimpleDateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Rcheckdate=df.format(rs.getDate("tr_dt")); %> <td align='center'><%=Rcheckdate%></td> In report i have given the excel button from there am exporting the data to … |
| | Hi I hope someone can shed some light on the problem I am having at the momment with an Excel 2010 Sheet, the workbook has 13 sheets with formulas and I rotate the 2 values using vba there are other things going on like a link to SQL server that …  |
| | Am having this piece of COde, but whenever am trying to execute this , Dim tsf As TestSetFactory - > error user not defined appears. pls help Dim tdc As TDConnection Sub UpdateStats() 'create QC connection QCconnect_silent "URL", "DOMAIN", "PROJECT", "USERNAME", "PASSWORD" 'process tests getMetrics 'disconnect QCdisconnect End Sub Private … |
| | hi there, i have an application that opens an excel file and get the values to the mdf file in visual studio database file. the code for opening the file is below [CODE] Microsoft.Office.Interop.Excel.ApplicationClass tt = new Microsoft.Office.Interop.Excel.ApplicationClass(); String path = a; tt.Workbooks.Open(path, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, … |
| | Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks  |
| | hey does anyone here knows how to change excel page orientation to portrait? i get landscape as default <?php header("Content-type: application/vnd.ms-excel"); header("Content-Disposition: attachment; filename=transactions.xls"); header("Pragma: no-cache"); header("Expires: 0"); ?> |
| | hi, i want to disable menu bar button(left-top) in office 2007 word document opened in windows form. please provide sample code. ASAP Thanks in advace... |
| | Hi All, I am tasked to generate report templates in excel and I am new to excel, VBA and still learning. A little more information on my task, the information for the report will be extracted from different sheets in the workbook which contains a whole list of calculation and … |
| | Hi, This is a problem googled easily, but no solution helped me. Locally I am trying to open a PowerPoint application to read and import a ppt (or pptx) file. this is the command where exception is thrown (ASP.NET VB): [CODE] objApplication = New Microsoft.Office.Interop.PowerPoint.Application [/CODE] the exception text is … |
 | Dear Daniweb members. I am having quite a troublesome time here with OleDb. What I am trying to achieve is to allow my users to connect to an uploaded Excel workbook, then to be able to select data from the sheets. I have a query designer in the front end … |
| | From this [article](http://www.daniweb.com/web-development/asp/threads/42314/exporting-asp-pages-to-excel) i found this code snippet that imports html data to excel: <% Response.ContentType = "application/vnd.ms-excel" Response.AddHeader "Content-Disposition", "filename=excelfile.xls" %> <table> <tr> <td>Category Name</td> <td>Category Description</td> </tr> <tr> <td>Software</td> <td>Holds data for software</td> </tr> <tr> <td>Hardware</td> <td>Hardware related data</td> </tr> </table> However, what i want to do is …  |
| | First of all, I realise there are a fair few related questions on many other sites, in addition to Microsoft Support pages. I have spent many hours on this issue, and this is where I stand and what I know/have been able to achieve: * I have an application written … |
| | Is it possible to alter Excel Viewer print settings via VB.NET and, if so, what is the syntax I need to do this? I would like my application to be able to change the printing preferences of an Excel spreadsheet opened in Excel Viewer (through the application via `Process.Start()`). This … |
| | Hello, I am trying to read values from an excel spreadsheet but just for specific cells at a time; say Cell A1 and B1. Then I want to save the respective values into a variable and use the variable through out the rest of the code. Then loop at the … |
| | I'm struggling to think of a reason why I should be getting an 'Access denied' error when trying to save an Excel document opened through a program written in VB 2010 Express. The program is essentially glorified Excel automation. It converts information from hundreds of Excel documents into a few …  |
 | Hi Guys.. I recently discovered that I am having issues with Windows Installer. I searched the web and tried a couple different things and finally found a thread on this site. I went through the steps and will post the results below. Also, when I open up Services, Windows Installer … |
| | I need Delphi 2011 XE code for editing an Excel file. If there is found a text in a row of column A of the Excel file, to change the number of the same row in column B. That's all I need. Thanks!  |
| | Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always …  |
| | Hi, I am trying to add content to an excel sheet using the below code. However, when I open the excel sheet, nothing is added. Please advice. public class StepNoToExcel { HSSFWorkbook wb = null; String fileName = "C:\\StepNoForEvidences.xls"; File file = null; StepNoToExcel() { file = new File(fileName); if(!file.exists()) … |
| | Hi, I have an application that converts the ascii characters within the excel file into hexa conversion ie. à to & #x00E0; but my application has one strict requirement and that is the excel file must be properly encoded in UTF-8. I have noticed that simply saving the excel file … |
| | So, I'm currently trying to open a .xls/.xlsx file, tell it to run a macro to refresh the workbooks, and then save the file as a different file name, thus leaving the original untouched. Now, technically, it is working, because the last person who held my position wrote a dll … |
| | i just upgraded a user from office 2007 to office 2010, now her documents that user to print in 2 pages is now printing on 4 pages and so on, please assist  |
| | I'd like to say "hello" to everyone as it is my first post. I looked for the solution to my problem on the internet for over 2 hours and I didn't find anything relevant. I hope you are able to help me. I have a bunch of invoices written in … |
| | Hi all, I am trying to read data from an excel file using "xlrd" functions. File contains many columns one of which is Date and time (in MM/DD/YYYY and HH:MM:SS AM/PM format). I am successful in reading all other type of data. But unfortunately for this column, program could read … |
The End.