473,395 Members | 1,742 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Perl OLE Excel Strange Problem

Hi Friends,
I am facing a strange problem while using WIN32::OLE for Excel Operations.

I am searching a string in log file & if string matches in excel, i am asigining values to certain cells from log file further parsing with certain conditions!

Everything goes fine except with Numbers.

Expand|Select|Wrap|Line Numbers
  1. if(m/.*\|TEST PARAM\|:: (.*) ::/){
  2. $Sheet -> Range("$TestParam$j") -> {Value} =    $1; #Ex. $1 = 21
  3.  
  4. $_    =    $Sheet -> Range("$TestParam$j") -> {Value};
  5. print "Test Param : $1, i = $i\n";
  6. print "Cell Contents (\@$TestParam$j) : $_\n"; #Verifying cell contents with 
  7. TempVar $1. Here Printing is fine, but in excel file, the contents are different 
  8. from what printed. 
  9. (While checking in excel after saved, the contents are related to '221' instead of 
  10. '21', as in my example)
  11.  
  12. }
  13.  
Please Help me!
Apr 13 '11 #1
1 1526
Sorry Friends, Its a code problem, Instead of doing Exact Match (Ex. 21) , i was doing Match Operation.
Apr 13 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Leif Wessman | last post by:
I'm using proc_open to write to a perl program. Sometimes (not always) the fwrite function below takes about 10 seconds to complete. Most of the time it takes about 0.001 seconds. I don't know what...
3
by: Sameh Halabi | last post by:
Hi I have a strange problem in C , I hope someone may help with it . the problem is as follows : I have an existing big structure (that I can't change) which contains in it groups of...
6
by: leonecla | last post by:
Hi everybody, I'm facing a very very strange problem with a very very simple C program... My goal should be to write to a binary file some numbers (integers), each one represented as a sequence...
1
by: Sam Kong | last post by:
Hello! Recently I had a strange problem with Visual C# 2005 beta 1. When I ran(F5 key) a program, <#if DEBUG> statement was not working. It ran as RELEASE mode. So I had to manually define...
12
by: ishtar2020 | last post by:
Hi everybody I've been writing my very first application in Python and everything is running smoothly, except for a strange problem that pops up every once in a while. I'm sure is the kind of...
0
by: riteshjain1982 | last post by:
Pagepostback.....strange problem Hi, I am at cient place and getting very strange problem with my asp.net application............when i call my web application from any desktop machine in lan...
10
by: vigacmoe | last post by:
I was trying to cast some strings to integers with stringstream, then this strange problem poped up. Here is my test code: stringstream conv; string from; int to; from = "1"; conv << from;
2
by: austboss | last post by:
I have an aspx page that retrieves data from several different sources and uses them to define a new GridView, which is the exported as an Excel file. I originally had all of the code required in...
1
by: Victor | last post by:
Hi guys, I have a very strange problem with scriptmanager here. I want to load a js (which is embed in the project) but everytime i try to load that, it gives me error like Specified argument was...
4
by: John Brock | last post by:
I have a .NET application that, among other things, creates Excel workbooks, and I have run into a very strange problem involving formulas on one worksheet that reference values on another...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.