One thing I'm seeing in your Excel-handling Perl is that you never write to the spreadsheet, nor do you save the Excel file. When using Win32::OLE, opening a file opens it for read/write, so you don't have to do anything differently there. The other thing I'm not sure about is your inner foreach loop -- why is it there at all if you only have one column? Not wrong per se, just curious.
Saving to Excel is really simple. Using kennethk's code (in this node), just add one line (with some surrounding lines to show location):
if ($citedby){
print "\"$title\"\nCited by: $citedby\n\n";
# Assuming you want to save the "cited" info in the
# column just to the right of the current cell, adjust
# as desired.
$Sheet->Cells($row,$col+1)->{Value} = $cited;
}
Then, of course, you'll want to call $Book->Save(); before you close the workbook.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|