Connecting over the internet from Calc

[vijay.openoffice]

Can I connect to a remote server from calc. Something similar to web browser component in MS Office.

[ttl]

Don't know if this is what you had in mind. Here is Java code that opens a URL accessing yahoo finance web site, reads the response and concatenates lines into a variable for subsequent processing.

String inputLine;
String response = "";
URL yahoo = new URL("http://download.finance.yahoo.com/d/quotes.csv?s=IBM&f=l1");
BufferedReader in = new BufferedReader(new InputStreamReader(yahoo.openStream()));
while ((inputLine = in.readLine()) != null)
{
response += inputLine;
}
in.close();

[vijay.openoffice]

Thanks. Actually I need to upload data from my local calc spreadsheet to a remote spreadsheet. Also need confirmation of successful data upload.