exporting exchange information

Special Forums Windows & DOS: Issues & Discussions exporting exchange information

08-01-2005

Registered User

195, 1

Join Date: Jan 2004

Last Activity: 22 December 2009, 5:54 PM EST

Location: Australia

Posts: 195

Thanks Given: 0

Thanked 1 Time in 1 Post

exporting exchange information

Hey all,

I have teh job of exporting all the information for around 500 e-mail addresses from exchange into something like a excel sheet.

I was pretty quiet one afternoon last week (and bore) so I added them to my adddresses book then exported them to excel. But I now have a problem, it does not export there e-mail address but there alias (e.i davidm & johns).

Doesn't anyone know how I can do this?

Cheers in advance!

woofie

View Public Profile for woofie

Find all posts by woofie

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

exchange values in a table - exchange numbers

Hello all, This is a bit simple but I cannot do it! I have a big table of values between 0 and 1. some cells have NA instead of having any value. I want to exchange all values with "1" and write "0" for all "NA" . for changing "NA" to zero I used sed: sed -i 's/NA/0/g' input.txt But...

2. Shell Programming and Scripting

Exporting or quering 2 issues

I need to export xlm files in a specific directory and insert them into an oracle table. I am new with unix. I also need to export users from ldap

3. Shell Programming and Scripting

exporting variable

Hi All; I m working on a script and came across an issue ,to explain it briefly here is the sample code echo $HOSTNAME|while read IN; do var=`echo $IN|awk -F "-" '{print $2}'`; export var; echo $var; done now I get the value of $var but when it is out of the while loop it does not return...

4. Solaris

variable exporting

Hi, can anyone tell me the difference between the below two examples: Eg-1: # name=bravo # echo $bravo what would be the o/p Eg-2: # name1=jhonny # export name1 # echo $name1 what would be the o/p If the o/p's of both examples are the same then what is the use of the cmd export...

5. Shell Programming and Scripting

Exporting to excel

Can someone help me out to export awk output to excel file in different rows? Plzzzz its urgent...:(

6. Solaris

Exporting X display question

I have a sun box i can connect to using exceed in broadcast or query mode. I have been using passive mode to call up just a few apps, xcalc for example. How do i get the solaris 9 user login screen using passive mode? is it dtlogin or something that im should run frmo the shell?

7. Windows & DOS: Issues & Discussions

Exporting data

My friend's boss has asked me to help update a customer database. They have a limited amount of space and have asked if I can do this from my home computer. She is working on a Unix system with a program called Accuterm. My understanding is that this program is a dedicated program for the...

8. UNIX for Dummies Questions & Answers

exporting display

how do I export my display from my unix box to my pc basically what is the syntax for export DISPLAY

9. UNIX for Advanced & Expert Users

exporting a directory

How do I export a directory ? I am trying to link the directory from another machine.

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)

Windows & DOS: Issues & Discussions