how to insert an object into a cell using JXL api..
i have a file which is not image.. i want to insert it into a cell of Excel sheet..
how can i achieve this?? please help...
I am so fed up with this google products I am Ready to give someone my UN and PS and pay them to do it. I keep getting a error message saying Text, I followed the instructions , they said to do it in excel and save as a text please
Help Please microcomputerctr.com
Given a simple data set, I would like to be able to calculate a trending formula given it's a second order polynomial regression.
In fact, it would be great if one could even forecast X periods during calculation (similar to what Excel does).
I'm looking for a portable C/C++ package that's relatively easy to use, and allows it to spit out the "best-fit" (highest R^2 value) curve.
Any suggestions? Thanks!
How to edit cell manually like in Excel:
Alt + Enter - line break (true break, not simply line break symbol on the same line)
Enter - exit from edit mode?
i have a rhel 4 server and use php as a server side scripting language. There are many doc and excel files that are uploaded to the server daily. i make these files to be downloaded. i want to implement the view as html feature and they should preserve the formatting also. so which tools can be used or it can be done through php only. (on php4)
I have a java code that reads an excel file and writes it to a text file. When i get the output text file, I can see only symbols like this in the notepad. "????????????????????????????" But if i open the text file in wordpad or ms-word, the data is correctly displayed. What could be the error?
We are using SQL Server 2005 Reporting Services (SSRS). We need to disable the hyperlinks for drill down reports while exporting the reports toexcel from report viewer. Is there any way to achieve this in SSRS 2005?
Hi,
what is the best way to see what all functions that can be performed using pythoncom module?
Specifically, i was working with the win32com module to operate upon excel files. I was not able to find introspection for it as we do for the rest of the modules.
Can anyone please suggest how can i retrieve this information?
What is the difference between the two. I always thought VBA is somewhat 'crippled' version of VB, but when a friend asked me the other day I had no idea what the actual differences are.
Also, when you use, for example, Excel, is that VB or VBA ?
I'm digging through Akamai logs, downloading excel sheets, and then manually joining them so that I can do sorting of data to find top videos and referrers. Are there any tools you know of to help with this kind of processing? I'm looking for something like Urchin used to be for Apache logs, but for Akamai logs. Thanks!
Hi,
I am creating a CSV from a list of values. CSV File gets created but the csv is formed as a single column. Actually it should be multiple rows with multiple columns, instead it forms as a multiple rows with a single column. I am using the following code
from random import choice
import csv
fileObject = csv.writer(open('Insurance.csv','w'),dialect='excel',delimiter=' ')
for i in range(0,175):
current_list = list(choice(master_list))
fileObject.writerows(current_list)
current_list = []
Thanks
Is there a jQuery plug-in to remap the "dot" key in the numeric keypad? The purpose is to make it print a decimal separator, rather than a dot, in languages that use commas or other characters. I'd like to mimic the behaviour of some desktop applications like MS Excel.
(It's okay to hard-code the output character.)
I am trying to create a tool that I can upload different types of files "csv", Excel, XML and load those files into a FileStream column in the database as "Source" untouched over the web. Then using SSIS on the server I want to create a package that will process that file to be loaded into other tables to be used by the web application.
Is it possible to have SSIS read a file from FileStream column? if so how?
Hi All,
I am creating a report from ssrs, and storing at local shared folder(MyReports) in excel format using data-driven subscription.
It generates a report on scheduled time. But, I don't wanna create a report with zero records.
How to stop SSRS to generate a report if no. of records is zero.
Pls F1 me ... !
I have an excel like grid where values can be typed referencing other rows
To check for circular references when a new value is entered, i traverse the tree and create a list of values referenced thus far, if the current value is found in this list, i return an error thus avoiding a circular reference. This is infrequent enough where extreme performance is not an issue but...
Question - is there a better way ? I'm told it's not the most optimal but no answer was provided so on to the experts @ SO :)
A lot of people like git (in particular this guy) against other SCMs such as SVN, but many projects, even new ones, are set up using alternative SCMs. Furthermore, Google Code still does not support it (although many of their large open source projects use it).
My question is: what are the reasons for not using git in any project, whether it be personal or collaborative? Maybe I've just been brainwashed by this guy, but I can't see any area in which other SCMs excel over git.
hi
i work with Office 2007 (excell) in my C# program.
i do this reference: Microsoft Excel 12.0 Object Library
it work excellent !, but if in the computer there is Office 2003
is it work good ? if not, what i need to do ?
thank's in advance
I am trying to figure out how you can print a file, for example an excel spreadsheet using the Win32 Printing and Print Spooler Functions. I know the path of the file, but don't have a clue to send it to the print spooler.
I am using OpenReports with a simple query (QueryReports) to generate reports. Once generated, only CSV, Excel and PDF are offered as formats for scheduled emails.
Would anyone know how to enable HTML or TXT for emailing? The version is 3.0.
I am using orbeon to process my xforms. I am attempting to create a data grid that I can use to copy and paste rows/columns of data from my clipboard (excel).
Do you have any clue how I can implement this?
Hi
We have a simple macro that connects Access and Excel (Office 2007 on Windows) with some forms and we are trying to create the iWork version, but I cant find how to create a macro or something, does anyone knows some manual or links to do this?
Im using iWork 09 on Snow Leopard.
Thanks!
Hi
I have invoice data stored in SQL now I want to print those invoices, It would probably take me less than an hour to print them manually but that is not the point I want to do it programmatically using c# What is the quickest simplest way? Excel? Links to some examples?
TIA
Stuart
Which .NET programming libaries do you use most ?
I'm putting together a list, kind of "best of" SourceForge, CodePlex, Google Code, GitHub, etc.
SourceForge.NET
Nhibernate (database ORM)
SharpZipLib (ZIP compression)
itextsharp (PDF library)
GitHub:
JQuery (JavaScript)
Google Code:
aforge (imaging)
Codeplex:
Excel Data-Reader
Other:
bouncycastle.org (Encryption)
Hi,
I have a Python script that takes the directory path of a text file and converts it into an excel file. Currently I have it running as a console application (compiled with py2exe) and prompts the user for the directory path through raw_input().
How do i make it such that I can drag & drop my text file directly into the .exe of the python script?
Thanks,
Currently I am using Apache POI for java to set formulas for cells, but the problem is after I run the program, and open the excel file that i created and processed with my java program, the cells with the formula included the formula as a string, rather than the value the formula should have returned.