Sending excel data to Tally

0 votes
I have a worksheet with macro support that stores the data in XML format. I created an excel template that stores the output file as an XML file. I then manually import the XML file using the import data option in Tally. I'm now seeking for a solution that would automate the process, meaning that as soon as I save the file in XML format, Tally should import the data automatically and instantly. I hope I made my question clear. I appreciate it. Sincere regards,
Nov 19 in Others by Kithuzzz
• 20,660 points
27 views

1 answer to this question.

0 votes

You can use Requests to send the xml to tally. Here's a C# example, you can translate it to your preferred language -

private static string Connect(string host, string request)
{
    string response = "";
    HttpWebRequest httpWebRequest = (HttpWebRequest)WebRequest.Create(host);
    httpWebRequest.Method = "POST";
    httpWebRequest.ContentLength = (long)request.Length;
    StreamWriter writer = new StreamWriter(httpWebRequest.GetRequestStream());
    writer.Write(request);
    writer.Close();
    HttpWebResponse httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
    Stream receiveStream = httpResponse.GetResponseStream();
    StreamReader reader = new StreamReader(receiveStream, Encoding.UTF8);
    response = reader.ReadToEnd();
    reader.Close();
    httpResponse.Close();
}
answered Nov 19 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
306 views
0 votes
1 answer

How to convert data from txt files to Excel files using python

Hi , there are few steps to ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
6,165 views
0 votes
0 answers

Importing notepad data to excel (difficult split)

I want to transfer this data from ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
64 views
0 votes
1 answer
0 votes
1 answer

Convert image (jpg) to base64 in Excel VBA?

Heres a function. Can't remember where I ...READ MORE

answered Sep 27 in Others by narikkadan
• 37,660 points
254 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
451 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,218 views
0 votes
1 answer

How to extract Bills receivable data to excel from tally by ODBC?

To obtain the company's receivable bills, you ...READ MORE

answered Nov 12 in Others by narikkadan
• 37,660 points
39 views
0 votes
1 answer

Unable to import data in excel from another website using VB code

Replace : Set ieTable = ieDoc.all.Item("report-table") With: Set ieTable = ...READ MORE

answered Sep 21 in Others by narikkadan
• 37,660 points
73 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP