Sending excel data to Tally

Question

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,

Answer 1

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();
}