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, 2022 in Others by Kithuzzz
• 38,020 points
834 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, 2022 by narikkadan
• 63,720 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, 2022 in Others by gaurav
• 23,260 points
7,696 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, 2022 in Others by Edureka
• 13,690 points
13,928 views
0 votes
0 answers

Importing notepad data to excel (difficult split)

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

Feb 18, 2022 in Others by Edureka
• 13,690 points
347 views
0 votes
1 answer
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, 2022 in Others by narikkadan
• 63,720 points
2,878 views
0 votes
1 answer

How can I preserve the format while exporting data from excel to evernote

The contents for an Evernote note are ...READ MORE

answered Jan 5, 2023 in Others by narikkadan
• 63,720 points
1,054 views
0 votes
1 answer

Create numbered XML nodes, set attributes when creating XML node

Just like createElement, createAttribute is a method of the xml ...READ MORE

answered Feb 20, 2023 in Others by Kithuzzz
• 38,020 points
1,034 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, 2022 in Others by narikkadan
• 63,720 points
1,127 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, 2022 in Others by narikkadan
• 63,720 points
702 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