[RESOLVED] Database creation

[A_Singh]

What my problem is that I need to create a database with all types of formats (underlined text, bolt text, italics text, bolt borders, etc..But the problem is that a .csv file doesn't support all these. If I create a spreadsheet, for all these purposes, excel shows them as corrupt, after editing using c++. What my basic code does is copies the exact content of one file to another, here is the code:

#include <iostream>
#include <conio.h>
#include <string>
#include <fstream>
using namespace std;

string line;

int main()
{

	ifstream inputFile;
	ofstream outputFile;
	inputFile.open("Hello.csv");
	outputFile.open("Hello1.csv");

	if (inputFile.is_open() && outputFile.is_open())
	{
		while (getline(inputFile, line))
		{
			 outputFile << line << endl;
		}


	}
	else
	{
		cout << "File not found" << endl;
	}
	return 0;
}

If there are any parts in the code, which make the file corrupt, please suggest changes.
If no, please suggest any other format of an excel file, which can be edited by c++.
Thanks for any answers and help in advance.

[VictorN]

1. Use the .xls or .xlsx format (as already suggested in some of your other thread).
2. To edit these file types from C++ code you should use Excel Automation. Search MSDN for details.

[2kaud]

is copies the exact content of one file to another

No it doesn't. It copies a text file (non-raw or 'cooked') to another file assuming that \n is the line termination character(s). If the input file is not a text file, then this method of file copying won't work.

What is the format of hello.csv? Can you attach a sample that the code in post #1 corrupts?

[GCDEF]

It would help if you were consistent with your terms. There's nothing in your post that has to do with database creation, and nothing in your code that edits anything. Saying a file becomes corrupt when you edit it with C++ doesn't tell us anything useful that we could provide help for. Also, a CSV file isn't really a database.

[A_Singh]

I'll surely attach my file, but see I am asking for a good file format to create a database which can even be edited by c++, and that's what I have mentioned in my topic.

[A_Singh]

And I'd be really pleased if you tell what can be a 'better' way of copying a CSV file to another.

[A_Singh]

Is office open XML right..?

[AvDav]

And I'd be really pleased if you tell what can be a 'better' way of copying a CSV file to another.

This could be accomplished using file mapping or with just filling file's content into memory then dump modified data into output file.
The same thing is proposed in another thread, but it does copying line-by-line which could be inefficient for large .csv files.

[A_Singh]

Thanks, can you help me with the code.

[AvDav]

No, there are lots of samples available in the internet.

[A_Singh]

Fine bro, thanks .

[A_Singh]

I have checked the internet, found some of them, also I’d be thankful if you can send me the link of one such sample(whenever you have time)

[VictorN]

What kind of database do you mean? Excel database? Or Ms Access one? Or some other database?
Anyway, you should access this database from your c++ code via some tools developed to work with databases. Such as ODBC classes or ODBC API, or via ADODB, or OLE consumer classes or ...

[2kaud]

I'll surely attach my file, but see I am asking for a good file format to create a database which can even be edited by c++, and that's what I have mentioned in my topic.

Have you looked at using existing databases like mySQL (https://www.mysql.com/products/community/), Microsoft SQL (https://www.microsoft.com/en-us/down....aspx?id=42299) etc? These can be easily used from c++.

[2kaud]

I'll surely attach my file

Where?