User Profile

padawanlinuxero · Feb 29 '08, 11:42 PM

hello

I am working on a excel file and I need to add a image a barcode in JPG, but everytime I run the program puts the image in the top part of the excel file and not where it should

this is what I use to put the image on the excel file

Code:

$Hoja -> Range("E47")->Select();
$excel->ActiveSheet->Pictures->Insert("c:\\projectword\\$filename2.jpg");

...

padawanlinuxero · Feb 21 '08, 06:05 PM

Hello !!!

I am working on a proyect in Perl that requires a codebar pdf417 since Perl module dont have any I found myself looking for a solution in the web, and found a program in source code, call pdf417_enc version 4.4, one thing is that is made for linux using C, I try to run it using Visual C++, but cant run it, on e of the errors is this one:

Linking...
LIBCD.lib(crt0. obj) : error LNK2001: unresolved...

padawanlinuxero · Jan 14 '08, 08:33 PM

good day

I have a problem, actually a big problem, I need to a plain xls file give it format, by format is adding an image, adding headers, adding rows at top of the file like 15 rows free, and I need to add text for titles of the report and stuff like that, so I thought I can do it with a macro, but I created a macro and where to save the macro?

I was reading the help on excel it said something about saving the macro...

padawanlinuxero · Jan 9 '08, 07:37 PM

I have a program that goes to a MySQL table and puts all the data of the table in a CSV file, now I want to leave 6 rows in blank at top of the file when open in Excel, but I dont know how to do that.

I use these to put all the data to into the csv file

Code:

my $sql = "SELECT * INTO OUTFILE 'c:/proyecto/$filename'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n' FROM t3132";

...

padawanlinuxero · Oct 22 '07, 02:28 PM

Hello all!!!

I am learning Perl here at my work, but right now I have a problem, I was reading about DBI, which is very cool since we use a lot of old DBF tables, so I am able to get the DBF data to CSV, but I was wondering is there a way to put it in MySql tables

I have here a small example to turn DBF to CSV but how to make it to MySql table? can you help me?

Code:

#!/usr/bin/perl
use

...

User Profile

Profile Sidebar

putting a image in a specific cell

I am kinda desperate please help

how to run a excel macro on perl ???

Add blank rows to a CSV file

Newbie with a problem