06-15-2013
In VBA, there is a system call, whose name temporarily escapes me, to run an external windows command. You could use that to e.g. telnet into the unix machine, run a script and harvest the result into a VBA variable, which then can be handed over to EXCEL.
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
i want to install ScO UNIX 5.1 in a windows 98 system.
i want it as a DUAL BOOT system. can i doit? If yes How.
and also i want to network unix with my clients. is it poosible to network both unix & windows thru a single network card.
if yes how?
also i wanted to know that thru a switch can i... (3 Replies)
Discussion started by: jigs
3 Replies
2. IP Networking
I have a client who is operating a SCO UNIX 4.3 server with Informix 4.12. My problem is that I need to get hold of the data using a Windows PC.
Where the hell do I start? :confused:
Thanks
Richard.
rgray@euriskotechnology.com (3 Replies)
Discussion started by: euriskotech
3 Replies
3. Shell Programming and Scripting
Hi,
Is there any method to connect unix box(Excecuting unix commands through Batch Files) through DOS prompt. (1 Reply)
Discussion started by: shekhar_ssm
1 Replies
4. UNIX for Advanced & Expert Users
Hey,
I need to setup a passwordless connectivity from one Unix machine to another unix machine.
I have the passwords for both the machines.
Need from
user@host1 to
user@host2
Please help.
Thanks,
Robin (3 Replies)
Discussion started by: robinbannis
3 Replies
5. AIX
Hi,
We have installed oracle on a AIX machine and when we try to connect to AIX machine from oracle client installed on a windows machine or do a telnet to AIX machine on 1521 port , it throws an error connection refused on port 1521 , where all the ports and firewalls are open from windows to... (2 Replies)
Discussion started by: adityakp123
2 Replies
6. Solaris
I have installed Open Solaris 10 on VMware which is hosted on Windows XP, my PC.
I would like to have a connection between Solaris and Windows, so that i can SSH/Telnet from windows to Solaris. I don't have any Internet connection.
Please help me with the network connection settings i have to... (3 Replies)
Discussion started by: mailsachin245
3 Replies
7. Shell Programming and Scripting
Hi,
I am trying to connect to the database through Unix serer using following command-
mysql -u root -Jepadt -D dtdatabase
But it giving me error -
mysql: unknown option '-J'
Can anybody help me to solve this problm
Thanks in advance
Please use code tags, thanks. (2 Replies)
Discussion started by: pspriyanka
2 Replies
8. Solaris
:wall:
Hello Solaris Users. Although a fundamental skill I am still new to connecting computers together in order that they can see each other, ie. via ping-ing of IP's and/or hostnames.
I wish to install Oracle 10g database on Sun Blade 1500 and access this from Windows XP laptop (running... (5 Replies)
Discussion started by: patcom
5 Replies
9. Shell Programming and Scripting
Hi,
I want a script for connecting teradata to load the file to teradata table.
Can you please help me out.
Thanks in advance. (1 Reply)
Discussion started by: victory
1 Replies
LEARN ABOUT DEBIAN
spreadsheet::xlsx
Spreadsheet::XLSX(3pm) User Contributed Perl Documentation Spreadsheet::XLSX(3pm)
NAME
Spreadsheet::XLSX - Perl extension for reading MS Excel 2007 files;
SYNOPSIS
use Text::Iconv;
my $converter = Text::Iconv -> new ("utf-8", "windows-1251");
# Text::Iconv is not really required.
# This can be any object with the convert method. Or nothing.
use Spreadsheet::XLSX;
my $excel = Spreadsheet::XLSX -> new ('test.xlsx', $converter);
foreach my $sheet (@{$excel -> {Worksheet}}) {
printf("Sheet: %s
", $sheet->{Name});
$sheet -> {MaxRow} ||= $sheet -> {MinRow};
foreach my $row ($sheet -> {MinRow} .. $sheet -> {MaxRow}) {
$sheet -> {MaxCol} ||= $sheet -> {MinCol};
foreach my $col ($sheet -> {MinCol} .. $sheet -> {MaxCol}) {
my $cell = $sheet -> {Cells} [$row] [$col];
if ($cell) {
printf("( %s , %s ) => %s
", $row, $col, $cell -> {Val});
}
}
}
}
DESCRIPTION
This module is a (quick and dirty) emulation of Spreadsheet::ParseExcel for Excel 2007 (.xlsx) file format. It supports styles and many of
Excel's quirks, but not all. It populates the classes from Spreadsheet::ParseExcel for interoperability; including Workbook, Worksheet,
and Cell.
SEE ALSO
Text::CSV_XS, Text::CSV_PP
http://search.cpan.org/~hmbrand/
A pure perl version is available on http://search.cpan.org/~makamaka/
Spreadsheet::ParseExcel
http://search.cpan.org/~kwitknr/
Spreadsheet::ReadSXC
http://search.cpan.org/~terhechte/
Spreadsheet::BasicRead
http://search.cpan.org/~gng/ for xlscat likewise functionality (Excel only)
Spreadsheet::ConvertAA
http://search.cpan.org/~nkh/ for an alternative set of cell2cr () / cr2cell () pair
Spreadsheet::Perl
http://search.cpan.org/~nkh/ offers a Pure Perl implementation of a spreadsheet engine. Users that want this format to be supported in
Spreadsheet::Read are hereby motivated to offer patches. It's not high on my todo-list.
xls2csv
http://search.cpan.org/~ken/ offers an alternative for my "xlscat -c", in the xls2csv tool, but this tool focusses on character encoding
transparency, and requires some other modules.
Spreadsheet::Read
http://search.cpan.org/~hmbrand/ read the data from a spreadsheet (interface module)
AUTHOR
Dmitry Ovsyanko, <do@eludia.ru<gt>, http://eludia.ru/wiki/
Patches by:
Steve Simms
Joerg Meltzer
Loreyna Yeung
Rob Polocz
Gregor Herrmann
H.Merijn Brand
endacoe
Pat Mariani
Sergey Pushkin
ACKNOWLEDGEMENTS
Thanks to TrackVia Inc. (http://www.trackvia.com) for paying for Rob Polocz working time.
COPYRIGHT AND LICENSE
Copyright (C) 2008 by Dmitry Ovsyanko
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or,
at your option, any later version of Perl 5 you may have available.
perl v5.10.1 2010-05-16 Spreadsheet::XLSX(3pm)