Hi, I'm creating an invoice at the moment, and there's going to be varying amounts of text on each invoice. Ideally I'd like to be able to enter content, and as soon as I do that, it'll create a border along the bottom of that row, from A to K if that makes sense. Is this possible? Cheers :) ...
I'm displaying a table of data: [Name] [Tel] [Email] [checkbox] Name 1 000 [email protected] Name 2 000 [email protected] (checked) Name 3 000 [email protected] (checked) (BUTTON TO DOWNLOAD CHECKED IN XLS) What I'm trying to achieve here is to create this button which will allow the user to download all checked entries in an XLS file? ...
Hi, I want to convert my sql data to csv files while clicking on a button. The code fragments I found for sql to CSV conversion were in PHP, and I'm trying to convert it to CakePHP since I'm working in CakePHP. Here is the PHP code I'm tring to convert: $result = mysql_query("SHOW COLUMNS FROM ".$table.""); $i = 0; if (mysql_num_rows($...
I am running 3 virtual machines that are running tests using cc.net server. Currently tests are running simultanously on 3 machines. All the tests require to access Excel file. When tests run individually they all work fine but running them on virtual server is causing this error. Any idea how to resolve this issue. ...
Somebody really needs to fix this "subjective questions evaluator" I usually compile my functions in a DLL and call them from excel. That works fine (well, let's just say it works) Unfortunatelly, python cannot be compiled. I know of py2exe but I don't know that it can make a DLL. So, ..., is there any other way ? I appreciate all ide...
I created a model in Excel to use in conjunction with Solver. It mostly works. The only problem is that Solver is not really treating the cells constrained as binary properly. When it's done finding a solution, some of the numbers are actually 0.9999996, 1.0000000003, 0.0000017, and so on. I am using Excel 2004 on Mac OS X. Here's what ...
I am not a programmer and have a very very limited knowledge about both VB coding and Java scripting. I have a software which can be currently run through a Java script. The software does some caluculations and saves the result file in a folder. I just want an example of Excel macros which could run this Java script, this way I wont have...
Simple question. Does anyone know an easy way to convert SpreadsheetML (Excel 2003 XML) to the Open Document XML used for Excel 2007 (xlsx) files? I've got a library that unfortunately doesn't read the XML format, so I need to try and find a way to read the data, that doesn't involve another library. Any suggestions appreciated. ...
This isn't really a question, more of an issue I ran across that I hope others can avoid. If anyone can test in Office 2002, 2007, and 2008/Mac, that may add some important context. Before replying, please note that Microsoft has released two XML-based formats for spreadsheets: SpreadsheetML and Office Open XML (aka "xlsx"). I've only ...
Hi guys, I need to find a program that can help me transfer the weight on the scale http://global.dymo.com/enUS/Products/10%5Flb%5F%5FUSB%5FMailing%5FScale.html onto Microsoft excel. Can someone help me out or point me in the right direction? The scale does signify that the reading has stabilized and I think that is the cue for it to wr...
HI, I need to expand column width of the grid view by dragging it to suitable length like we do in excel after selecting a column.Is it possible? ...
I'm writing a tool that syncs a simple database with Excel sheets. Each item in a table in the database corresponds to one row in the worksheet. I read the Excel into the tool using C# and the Excel interop com interface, and compare the items' values (i.e. one of the columns in the excel sheet) after the sync just to make sure that they...
Hi, Can anybody tell me, how can we add hyperlink in Excel[2007] to one of its worksheet? i.e. from one tab to another tab [Within excel] . Thanks, Amit ...
Been investigating for a while now and keep hitting a brick wall. I am importing from xls files into temp tables via the OpenRowset command. Now I have a problem where I’m trying to import a certain column has a range values but the most common are the following. Columns structured as long numbers i.e. 15598 and the some columns as stri...
Hi gurus, I was able to do fill tables with data from Excel file or text files using GUI utility Teradata Sql assistant. But now I have a requirement to import data into teradata tables from excel file using a bteq script. I have been trying to do that using .IMPORT REPORT .IMPORT DATA .IMPORT VARTEXT and I have tried other things also,...
INTRODUCTION I'm using excel downloads as a way of users downloading a score sheet, filling out scores and then re-uploading this score sheet into the system. Part of this requires the data in the database to be put into a CSV. Then its opened on the client computer. PROBLEM The problem I'm having is that the CSV does not allow me to...
Hi, Im trying to import data into tables from a file using BTEQ import. im facing weird errors while doing this Like: if im using text file as input data file with ',' as delimiter as filed seperator im getting the error as below: *** Failure 2673 The source parcel length does not match data that was defined. or if im using EXCEL f...
Can you create a unique identifier in Excel 2007. I'm looking for the same value generate by the SQL Server function newid(). Thanks ...
How do I count the number of cells that contain the string "A*" - without treating the star as a wildcard character? ...
As per my Application (VBA), it scan the excel sheet and then convert Active-X controls to Form Control if any. Need to implement: If the nested grouping is there then we need ungroup all the sub group and then convert the controls into Form controls and then again group all the controls as it is. Issue: Unable to group the controls ...